NLS_SORT

From: José Ortuño <gpaloma_at_cesser.com>
Date: Sat, 19 Jun 1999 11:55:16 +0200
Message-ID: <7kfp17$gdv$1@talia.mad.ttd.net>

Hi :

I have a problem with ORACLE for NT 8.0.5.0.

Default value for parameter NLS_SORT is BINARY .

In a table run EXPLAIN and result SORT.

With SQL+ runing ALTER SESSION SET NLS_SORT = BINARY

run EXPLAIN and acces by INDEX.

In file INITORACL.ORA

NLS_SORT = BINARY SHUTDOWN and RESTART.

With INSTANSCE MANAGER ===> NLS_SORT = BINARY but is necesary ALTER SESSION or SORT.

WHY? Sorry, I do not speak english.

Regards. Received on Sat Jun 19 1999 - 04:55:16 CDT