December 2002
Intermediate to advanced
928 pages
85h 29m
English
NLS_COMP
Value: BINARY | ANSI
Default: BINARY
Dynamic: ALTER SESSION
Specifies how comparisons in the WHERE clause of queries are performed. If ANSI, comparisons will use the linguistic sort specified in the NLS_SORT parameter instead of the normal binary comparison. You must have an index on the column on which you want to do a linguistic sort. New with Oracle8i.