To get the list of all possible nls parameters
sql>select parameter,value from x$ksulv;
The view for all nls parameters set on the DB
v$nls_parameters
To set nls_lang in Windows Clients : http://www.lazydba.com/oracle/0__30008.html
The priority for nls vaues
http://forums.oracle.com/forums/thread.jspa;jsessionid=8d92200830de6ace293677e74410ba14b54a0a1566d4.e34QbhuKaxmMai0MaNeMb3eKaN90?messageID=1499595?
Check out this link for more abt Oracle NLS Parameters
http://www.databaseanswers.org/ora_nls_support.htm
Its said in metalink as
================
Subject: Character Sets & Conversion - Frequently Asked Questions
Doc ID: Note:227330.1
These oracle stuffs might come in handy...
Friday, February 9, 2007
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment