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_at_rightnow.com> 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_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Received on Fri Apr 16 2004 - 14:04:46 CDT
