alter session set nls_date_format='dd-mm-yyyy', nls_language=Dutch, nls_currency='Eur' : nls_date_format « SQL PLUS Session Environment « Oracle PL/SQL Tutorial

1. Oracle PL/SQL Tutorial
2. SQL PLUS Session Environment
3. nls_date_format

SQL> alter session
  2  set   nls_date_format='dd-mm-yyyy'
  3        nls_language=Dutch
  4        nls_currency='Eur';

Session altered.

SQL>
SQL>