CODEWITHSUNDEEP
oracle-database
Centurion
Centurion

Reputation: 14304

Where is NLS_CHARACTERSET parameter in Oracle Enterprise Manager 11g?

Did logged into Enterprise Manager 11g via browser. There are NLS_TERRITORY, NLS_LANGUAGE and other NLS related params in In Server->Initialization Parameter->NLS group. But unable to find NLS_CHARACTERSET parameter. Explicit search of the parameters gives

"No parameters found".

Is "select * from nls_database_parameters" the only way to view its value?

Upvotes: 3

Views: 20966

Answers (2)

OraNob
OraNob

Reputation: 694

try 

SELECT value$ FROM sys.props$ WHERE name = 'NLS_CHARACTERSET'

Upvotes: 2

Matas Vaitkevicius
Matas Vaitkevicius

Reputation: 61391

Answer from @OraNob gave me 

ORA-00942: table or view does not exist

However this worked for me:

select * from v$nls_parameters where parameter in ('NLS_CHARACTERSET');

Upvotes: 2

Related Questions