1. 2016-11-15 - Change client session language in sqlplus; Tags: Change client session language in sqlplus
    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