Results 1 to 2 of 2

Thread: nls settings

  1. #1
    Join Date
    Aug 2008
    Posts
    464

    Unanswered: nls settings

    I understand
    select * from 'v$nls_parameters' shows the nls settings on the local PC and
    select * from 'sys****s_database_parameters' shows the nls settings on the oracle server?

    Please confirm?

    NOTE: There is supposed to be a . between sys and nls_database_parameters but when I try to save, it changes to asteriks and nl disappears....Wierd.
    Last edited by shajju; 10-06-09 at 06:44. Reason: correction

  2. #2
    Join Date
    Mar 2007
    Posts
    623
    Quote Originally Posted by shajju
    I understand
    select * from 'v$nls_parameters' shows the nls settings on the local PC and
    select * from 'sys****s_database_parameters' shows the nls settings on the oracle server?

    Please confirm?
    What about consulting it with the documentation? You should know its starting page already, as I posted it many times to you.
    Concentrate on the Reference book (or just search given names there).

Posting Permissions

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