Home » SQL & PL/SQL » SQL & PL/SQL » Specifying custom order for ORDER BY clause
Specifying custom order for ORDER BY clause [message #23700] Sat, 28 December 2002 22:18 Go to next message
Uday Chikorde
Messages: 1
Registered: December 2002
Junior Member
Hi

See the follwing table actran.

Actran
------

Book_no
-------
CSP
BNP
BNR
PCS
CSR

i want to make a qeury that can order the book_no filed by my given criteria by following order
CSR
BNR
PCS
CSP
present order by clause uses ascending or decending clause can anyone know how to specify user defined order by with using SQL query.

Thanks

Report message to a moderator

Re: Specifying custom order for ORDER BY clause [message #23702 is a reply to message #23700] Sun, 29 December 2002 06:48 Go to previous message
Remi
Messages: 28
Registered: December 2002
Junior Member
I use the following,

SELECT
*
FROM
actran
ORDER BY
DECODE (Book_no,
'CSR', '1',
'BNR', '2',
'PCS', '3',
'CSP', '4',
Book_no)
/

Good luck

Remi

http://ora-0000.com/

Report message to a moderator

Previous Topic: Oracle Privlages
Next Topic: Trigger Creation Help
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri May 17 13:54:59 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.