Name
NLS_COMP
Synopsis
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.
Get Oracle in a Nutshell now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.