> 
> I'm curious if there is any way to produce a listing of characters in the
> order that they are sorted on the Oracle database.  I can't seem to find this
> information anywhere.  I know Sybase offers a system procedure that will
> provide such a list.  I was wondering if Oracle offered the same.  Or is there
> documentation on the sort order that Oracle uses?  Is it specific to certain
> parameters used at install?  Does it vary with the machine that the database
> is running on?
>
You can type:
select chr(1) from dual;
select chr(2) from dual;
select chr(3) from dual;
...
select chr(256) from dual;

This will show you the ASCII map that Oracle uses to sort data.

Best of luck!


-Ari Kaplan
Independent Oracle DBA Consultant

<-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><->
<-> For 160+ Oracle tips, visit my Web Page:                      <->
<->                                                               <->
<->             www.arikaplan.com                                 <->
<->                                                               <->
<->             email: akaplan@interaccess.com                    <->
<-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><->

Back to Ari Kaplan's Home Page i Kaplan's Home Page