order by question

From: geraldine_2@xxxxxxxxxxx
To: oracle-l@xxxxxxxxxxxxx
Date: Wed, 30 Mar 2005 14:07:00 +0000

Hi,
I have the following data in a table:

SQL> select * from test order by name;
NAME
----
pen
Pen
cat
CAT


I want to order the records in alphabetically order first, followed by upper 
case and then lower case.

The result should be :
CAT
cat
Pen
pen

I tried order by upper(name) but that did not yield the right result.

Can someone shed some light. 

Thanks.

Geraldine
--
http://www.freelists.org/webpage/oracle-l

Follow-Ups:

Re: order by question
From: John Clarke

order by question

Other related posts: