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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
