How to check Oracle database characterset (NLS parameters)

I often get questions about Oracle database NLS parameters, especially about characterset, it’s very easy to check this parameters with command:
for only characterset

select value from nls_database_parameters where parameter='NLS_CHARACTERSET';

for all nls_parameters :

SELECT * FROM nls_database_parameters;

but many of this parameters are overwritten in session level, hence we can check this parameters in session level with command:

select * from nls_session_parameters;

that’s all,
good luck.

One thought on “How to check Oracle database characterset (NLS parameters)

  1. Ravikiran

    I want TImestamp as DD-MON-YYYY hh:mm;ss format when i import the data to excel, please suggest.

    Reply

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s