How can I alter the parameter nls_sort

From: <gzjacklee_at_gmail.com>
Date: Mon, 23 Jun 2008 01:59:37 -0700 (PDT)
Message-ID: <a9d36b99-bd0f-4382-ad52-674fa475c3fd@x19g2000prg.googlegroups.com>


I used "alter system set nls_sort = binary_ci scope = spfile" to change the default value of the parameter nls_sort.Then I restarted the service of the database instance.I saw the instance value has changed.Now the problem is when I create a new connection the value of nls_sort was not binary_ci but binary.I don't know why the session value was not changed.

any advice will be appreciated!

Thanks a lot
Jack.Lee Received on Mon Jun 23 2008 - 03:59:37 CDT

Original text of this message