Get NLS info for your DB

From Peter Pap's Technowiki
Revision as of 00:48, 14 January 2013 by Ppapa (talk | contribs) (Created page with "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_PAR...")

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
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;