| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: displaying result sets in the order listed in the IN list
this is not possible in the relational world.
to me this sounds like the famous "missing attribute" issue;
if this order is important for whatever reason, they forgot to design it
properly.
anyway, it is impossible to make the order of elements listed in an IN-list
change the order of your result; you will need some other attribute (the
missing one) for an ORDER BY clause.
Kind regards,
Lex.
visit my website at: http://www.naturaljoin.nl <http://www.naturaljoin.nl>
-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Ivan Chow
Sent: Friday, April 16, 2004 18:35
To: oracle-l_at_freelists.org
Subject: displaying result sets in the order listed in the IN list
Hello,
I have a table that has the following values:
select * from mytab;
mycol
select * from mytab where mycol in (3,1,4);
mycol
Is it possible to display the values of mycol in the order the literal values are listed in the IN list? The IN list string 3,1,4 is passed in by another program and it can be listed in any order. I need the results to be display in whatever the order is in the IN list.
My expected result is
mycol
Is that possible? If not, any suggestions?
thanks in advance.
Ivan C.
 |
 |