order by question

From: <geraldine_2_at_comcast.net>
Date: Wed, 30 Mar 2005 14:07:00 +0000
Message-Id: <033020051407.5962.424AB283000E9FCC0000174A2200762194CDA10A02070B040E9D0A09@comcast.net>

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 Received on Wed Mar 30 2005 - 09:10:44 CST