Showing posts with label oracle nls parameters. Show all posts
Showing posts with label oracle nls parameters. Show all posts

Friday, October 2, 2009

How To Find Your Characterset in Oracle

Got a request today from an application owner asking what NLS characterset we are using in our Oracle database (10g). Just ran the following simple query to find out:

select * from NLS_DATABASE_PARAMETERS where PARAMETER = 'NLS_CHARACTERSET';