To validate NLS_LENGTH_SEMANTICS parameter:- v$parameters or v$nls_parameters
Hi All,
I need to validate NLS_LENGTH_SEMANTICS either BYTE or CHAR.
Please let me know which view should use to validate . v$parameters or v$nls_parameters.
select value from v$parameter where name = 'nls_length_semantics' Not validateing nls_session_parameter.
Please see following
1. SQL> select * from nls_instance_parameters where parameter like 'NLS_LENGTH%';
PARAMETER
--------------------------------------------------------------------------------
VALUE
--------------------------------------------------------------------------------
NLS_LENGTH_SEMANTICS
BYTE
2. SQL> select * from nls_database_parameters where parameter like 'NLS_LENGTH%'
2 ;
PARAMETER
------------------------------
VALUE
--------------------------------------------------------------------------------
NLS_LENGTH_SEMANTICS
BYTE
3. SQL> select * from nls_session_parameters where parameter like 'NLS_LENGTH%';
PARAMETER