Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Please ask technical questions in the appropriate category. Thank you!

Sort order

464177Nov 1 2005 — edited Nov 3 2005
Your help is appreciated. Basically I would like to sort the character in alphabetical order regardless to the case. However, if the alphabet is the same, then I would like to sort by lower to upper case.

For example, I have the followings in my table:

aA
Aa
ab
aC
bC
Bz
C1
Cz

and I would like to sort this column in the following order, is there a way I can do this?

aA
ab
aC
Aa
bC
Bz
C1
Cz

Thanks
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 1 2005
Added on Nov 1 2005
5 comments
8,439 views