NLS parameters
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: NLS parameters

  1. #1
    Join Date
    Nov 2002
    Location
    INDIA
    Posts
    38

    NLS parameters

    Hi All,
    Does any view provide the information of all NLS parameters thet the system is currently using.

    Cheers,

    Paddy

  2. #2
    Join Date
    Nov 2000
    Location
    Israel
    Posts
    268
    Hi,
    you can query these views to obtain a list of current NLS parameters in the database:
    NLS_SESSION_PARAMETERS;
    NLS_INSTANCE_PARAMETERS;
    NLS_DATABASE_PARAMETERS;

    You can view the entire list of parameters and values using :
    V$NLS_PARAMETERS;
    V$NLS_VALID_VALUES;

    Cheers.
    It is better to ask and appear ignorant, than to remain silent and remain ignorant.

    Oracle OCP DBA 9i,
    C++, Java developer

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width