Oracle Database Discussions

Dear Friends ,

In oracle12c database , I have to change one of parameter 'nls_length_semantics' = 'CHAR' using below command :

   alter system set nls_length_semantics=char scope=both;

Also,

    alter system set nls_length_semantics=spfile;

Now the problem is when I take the query from NLS_DATABASE_PARAMETER , then everytime it shows :

SQL> SELECT * FROM NLS_DATABASE_PARAMETERS where parameter = 'NLS_LENGTH_SEMANTICS';

PARAMETER                                              VALUE

------------------------------                            ----------------------------------

NLS_LENGTH_SEMANTICS                      BYTE

But all other parameter shows CHAR ..

SQL> show parameter nls_leng

NAME                                 TYPE        VALUE

------------------------------------ ----------- ------------------------------

nls_length_semantics                 string      CHAR

ALSO ,

nls_length_semantics                 string      CHAR

SQL> select parameter,value from v$nls_parameters where Parameter = 'NLS_LENGTH_SEMANTICS';

PARAMETER

----------------------------------------------------------------

VALUE

----------------------------------------------------------------

NLS_LENGTH_SEMANTICS

CHAR

Can anybody explain why it is happening ?

Also How can I set output as 'CHAR' on the  'NLS_DATABASE_PARAMETERS'  output ?