Loading...

Change client session language in sqlplus

If you are working with Oracle you may experience unexpected behaviors considering your Oracle’s National Language Support (NLS). Some SQL statements to setup properly for your working session.

SQL> ALTER SESSION SET NLS_LANGUAGE=ENGLISH;
Session altered.
SQL> ALTER SESSION SET NLS_TERRITORY=SWITZERLAND;
Session altered.
SQL> select current_timestamp from dual;
CURRENT_TIMESTAMP
---------------------------------------------------------------------------
15.11.16 07:38:20.420000 +01:00