Get NLS info for your DB

From Peter Pap's Technowiki
Jump to navigation Jump to search

This will get you the NLS_Character set:

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

This will get you all the NLS info:

 SELECT * FROM NLS_DATABASE_PARAMETERS;