Re: sorting: parentheses

Likely you have database instances created with different character sets.

Daniel Morgan

Tom Odul wrote:

> My Oracle: Oracle 8i Enterprise Edition, Release 2, Version 8.1.6 for
> Windows NT/2000
>
> I have a problem sorting records which start with parentheses.
>
> I want to sort them like this:
>
> rex
> sedes
> (sedes
> timor
>
> It works on my Windows2000/Oracle server, but when I export/import the db to
> a NT4/Oracle server, it sorts like this:
>
> (sedes
> rex
> sedes
> timor
>
> At http://www.stylusinc.net/technology/Oracle9i/sorting.shtml, I read that
> you can modify the sorting capabilities of Oracle 9. Does anyone know if
> it's possible in Oracle 8, how to do it, and if it will fix my problem?
>
> Thanx in advance
>
> Tom
Received on Mon Mar 25 2002 - 10:27:42 CST