The CentOS distribution is a famous and stable Linux version derived from RedHat Linux. It’s been one of my favorites and one that you can easily find with hosting providers.

In this article we will install CentOS and OracleXE. It’s worth mentioning …

This post will be updated with snippets for Oracle. I hope you find it useful.

1. Change the default date format

Most useful snippet of the year! 😉

1ALTER SESSION SET NLS_DATE_FORMAT = 'MM/DD/YYYY HH24:MI:SS';
2select sysdate from dual;

2. …