Finally, you can change the default DATE format of Oracle from “DD-MON-YY” to something you like by issuing the following command in sqlplus:
alter session set NLS_DATE_FORMAT=’dd-MM-yyyy’;
The change is only valid for the current sqlplus session.
Finally, you can change the default DATE format of Oracle from “DD-MON-YY” to something you like by issuing the following command in sqlplus:
alter session set NLS_DATE_FORMAT=’dd-MM-yyyy’;
The change is only valid for the current sqlplus session.