Get NLS info for your DB

From Peter Pap's Technowiki
Jump to: navigation, 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;