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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

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

Processing
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,105 views