Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: How to get "...WHERE test IN (5,23,2,12,56)" in this order

Re: How to get "...WHERE test IN (5,23,2,12,56)" in this order

From: Brian Tkatch <SPAMBLOCK.Maxwell_Smart_at_ThePentagon.com.SPAMBLOCK>
Date: Fri, 11 Jan 2002 13:49:54 GMT
Message-ID: <3c3eed53.282021063@news.alt.net> 





On 10 Jan 2002 12:07:56 -0800, Thomas Kyte <tkyte_at_us.oracle.com>
wrote:



>SQL> select *

>  2    from t

>  3   order by instr( ',' || '5,23,2,12,56' || ',', ',' || x || ',' );

>




Now that is nice!



Brian
Received on Fri Jan 11 2002 - 07:49:54 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US