Sorting in a query

  • From: "Gaston, William" <wgaston@xxxxxxx>
  • To: <Oracle-L@xxxxxxxxxxxxx>
  • Date: Fri, 10 Dec 2004 10:01:59 -0700

I have an odd problem.  I have a list of numbers that serve as 
extract parameters in a query select ...where x in number list).  
The numbers are in a specific sequence which does not match 
the sequence of the extracted data.  The user wants the data in 
the same order as the list of numbers supplied.  Is there any easy 
way to do this within the query?
 
Thanks for any help.
 
Bill
 
William Gaston
Systems Designer / Information Technology
USG Corporation
Chicago, Il 60606
(312) 606-3851
wgaston@xxxxxxx
 
--
//www.freelists.org/webpage/oracle-l

Other related posts: