Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

NLS Parameters

Eslam_ElbyalyJul 11 2014 — edited Jul 15 2014

db 10g , dev 10g rel2 , win 8 ,

hi

,

what is the diff between these queries :

SELECT * FROM nls_session_parameters;

SELECT * FROM nls_instance_parameters;

SELECT * FROM nls_database_parameters;

1- which one should i use to see the default values and formats for parameters ?

2- are there any other tables i can use for getting parameters' values ?

thank you

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 12 2014
Added on Jul 11 2014
10 comments
67,836 views