Difference between revisions of "Get NLS info for your DB"

From Peter Pap's Technowiki
Jump to: navigation, search
(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...")
 
(No difference)

Latest revision as of 00:48, 14 January 2013

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;