Skip to Main Content

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 - numbers first and then the alphabets ?

551174Jan 9 2009 — edited Jan 12 2009
Hi,

I have a list of names
starting with space, starting with numbers and some starting with upper case and then some starting with lower case letters.

The default order by sorts is - spaces, numbers, upper case alphabets and lower case alphabets.

But I want to order the names by spaces first, lower case alphabets, upper case alphabets and then the numbers.

How do i do this? Any help is appreciated.

thanks
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 9 2009
Added on Jan 9 2009
3 comments
5,266 views