RE: displaying result sets in the order listed in the IN list
- From: Rachel Carmichael <wisernet100@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Fri, 16 Apr 2004 12:07:52 -0700 (PDT)
not always ... we have an application that dynamically generates the IN
list (dynamic sql, the users can pass in enough information to force us
to generate an IN list with over a thousand items in it, don't ask!)
Dan's approach works for something like that. Fortunately, we don't
have to order the results but if we did.........
--- "Orr, Steve" <sorr@xxxxxxxxxxxx> wrote:
> Well an IN list is usually pretty small/static so it wouldn't be hard
> to
> use a decode on the same values.
>
--------------------------------------
__________________________________
Do you Yahoo!?
Yahoo! Tax Center - File online by April 15th
http://taxes.yahoo.com/filing.html
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
