These oracle stuffs might come in handy...

Friday, February 9, 2007

NLS Parameters

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

No comments: