Loading...

Change client session language in sqlplus

:heavy_exclamation_mark: This post is older than a year. Consider some information might not be accurate anymore. :heavy_exclamation_mark:

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