Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle Sort

Re: Oracle Sort

From: Valery Yourinsky <vsu_at_bill.mts.ru>
Date: Wed, 17 Oct 2001 12:41:39 +0400
Message-ID: <3BCD4443.DBD69D97@bill.mts.ru>


Fredy Tschui wrote:
>
> How can i change the sort "type" in oracle 8i ?
>
> Currently (special charachters are ignored)
> "a", "b", "(c", "d", "(e"
>
> but i need this:
> "(c", "(e", "a", "b", "d"

   alter session set nls_sort = binary;

Valery Yourinsky

-- 
Oracle8 Certified DBA
Moscow, Russia
Received on Wed Oct 17 2001 - 03:41:39 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US