Set date+time (NLS_DATE_FORMAT)

July 30, 2012 admin Oracle

SQL> alter session set nls_date_format=’DD/MON/YY HH:MI:SS PM’;

Session altered.

SQL> select sysdate from dual;

SYSDATE
———————
27/MAY/11 10:33:31 AM

Create a DBMS_JOB Check Oracle Version Installed