janu wrote:
> Hi Laurenz A,
>
> I set my system setting to BINARY_CI
>
> sql>alter system set nls_sort=binary_ci scope=both;
>
> My question is ,why there is difference between database_properties and
> V$parameter.
>
> Thank you
> RA

I'm guessing what you are seeing is the difference between how Oracle
sorts (binary) and whether it uses case insensitivity (binary_ci).
This varies based on which sql verbs you are using (see metalink
Note:263083.1). Since nls_sort is the collating sequence used, Oracle
must somehow keep track of all the derivations of it. Perhaps the bug
is both views should have both attributes. What happens when you set
your language to, say, CATALAN?

This certainly could be documented better, perhaps an SR is in order,
we shouldn't have to guess.

jg
--
@home.com is bogus.
http://www.engadget.com/2006/12/12/l...igner-glasses/