Oracle PL/SQL/Date Timezone/NLS DATE FORMAT

NLS_DATE_FORMAT: Find out system default data format

SQL>
SQL> --Find the NLS_DATE_FORMAT:
SQL>
SQL> SELECT value FROM v$nls_parameters WHERE parameter ="NLS_DATE_FORMAT";
VALUE
----------------------------------------------------------------
DD-MON-RR
SQL>