Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> cusotm sort in order by
I like to sort the rows of a table in a custom order of a column.
Say the table T(A,B) has values for B as
'Snake' 'Dog', 'Horse', 'Elephant'.
I would want the select to list the values in the order
'Dog' 'Hosrse' 'Snake' 'Elephant'. (** Not in ASC or DESC orders)
Would appreciate any help.
--
Nandakumar
Systems Analyst
New York
(N.Kumar_at_rocketmail.com)
Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't.
Received on Mon Aug 02 1999 - 18:31:07 CDT