Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Sort Hex value

SowmyRajJan 31 2009 — edited Jan 31 2009
Hi,

I've got a varchar2-column that contains a hexadecimal number (0-9, A-F).

Using "order by", Oracle sorts it like this:

A10
BFF
010
900

I would like it to be sorted in the natural order, like this:

010
900
A10
BFF

Any ideas?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 28 2009
Added on Jan 31 2009
1 comment
937 views