Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback, please email oracle-forums_moderators_us@oracle.com

SQL Order question

513167Mar 12 2007 — edited Mar 12 2007
Dear all,
My table have a field e.g. colA varchar2(2) which stored number. The data stored in this field like that: 88, 89, 90, 91, ...99, 00, 01, 02, ..., 08 etc.
I don't know how to order the number like that: 08, ..., 02, 01, 00, 99 ... , 91, 90, etc.
Any idea?

Thank you!

Regards.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 9 2007
Added on Mar 12 2007
6 comments
1,710 views