RE: order by question
- From: "Mercadante, Thomas F" <thomas.mercadante@xxxxxxxxxxxxxxxxx>
- To: "'geraldine_2@xxxxxxxxxxx'" <geraldine_2@xxxxxxxxxxx>, oracle-l@xxxxxxxxxxxxx
- Date: Wed, 30 Mar 2005 09:17:27 -0500
What version of Oracle? When I do this (on 9.2.0.4) I get:
Cat
Pen
cat
pen
-----Original Message-----
From: geraldine_2@xxxxxxxxxxx [mailto:geraldine_2@xxxxxxxxxxx]
Sent: Wednesday, March 30, 2005 9:07 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: order by question
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
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
