Hlavní navigace

Názor k článku Jak nepoužívat PL/pgSQL (případně PL/SQL) – fatální chyby při vývoji od Martinus - Jeste doplnim .. env variable na to nema...

Článek je starý, nové názory již nelze přidávat.

  • 24. 5. 2018 13:38

    Martinus (neregistrovaný) 188.122.208.---

    Jeste doplnim .. env variable na to nema vliv, pouze alter session, po prihlaseni opet hodnota z spfile:

    SQL> hradec:~ $ env|grep NLS
    NLS_SORT=BINARY
    hradec:~ $ sqlplus sort

    SQL*Plus: Release 11.2.0.4.0 Production on Thu May 24 07:33:33 2018

    Copyright (c) 1982, 2013, Oracle. All rights reserved.

    Enter password:

    Connected to:
    Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
    With the Partitioning, OLAP, Data Mining and Real Application Testing options

    SQL> select * from NLS_INSTANCE_PA­RAMETERS where parameter in ('NLS_SORT','NLS_COM­P');

    PARAMETER VALUE
    ------------------------------ ----------------------------------------
    NLS_SORT BINARY_CI
    NLS_COMP LINGUISTIC

    SQL> show parameter nls_sort

    NAME TYPE VALUE
    ------------------------------------ ----------- ------------------------------
    nls_sort string BINARY_CI
    SQL> alter session set nls_sort=binary;

    Session altered.

    SQL> show parameter nls_sort

    NAME TYPE VALUE
    ------------------------------------ ----------- ------------------------------
    nls_sort string BINARY

    SQL> exit
    Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
    With the Partitioning, OLAP, Data Mining and Real Application Testing options
    hradec:~ $ sqlplus sort

    SQL*Plus: Release 11.2.0.4.0 Production on Thu May 24 07:34:31 2018

    Copyright (c) 1982, 2013, Oracle. All rights reserved.

    Enter password:

    Connected to:
    Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
    With the Partitioning, OLAP, Data Mining and Real Application Testing options

    SQL> show parameter nls_sort

    NAME TYPE VALUE
    ------------------------------------ ----------- ------------------------------
    nls_sort string BINARY_CI