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!

Sorting of alpha numeric characters in a column`

brainstormerSep 14 2007 — edited Jun 8 2011

Hi All,

I have a column which has alpha numeric characters like 1A, 12B, 14D, 12CC ...etc.

I need to sort this column in ascending as well as descending. The normal "sort by" does not work and the ASCII function return on the ascii value of the 1st character in the cell.

Can you please help me out?

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 6 2011

Added on Sep 14 2007

19 comments

8,963 views