Re: Pass multiple numeric values to a function
- From: Greg Rahn <greg@xxxxxxxxxxxxxxxxxx>
- To: ravigaur1@xxxxxxxxx
- Date: Thu, 12 Feb 2009 17:47:47 -0800
On Thu, Feb 12, 2009 at 11:29 AM, Ravi Gaur <ravigaur1@xxxxxxxxx> wrote:
> One of our developers is trying to write a function that accepts multiple
> values (all numbers) that he can use inside the IN clause of the query.
Sometimes a question is the best first response... Why does this
developer want to approach the problem this way?
Not knowing what the problem is at hand, an alternative suggestion
would be to use a table function so a join could be used instead of a
variable length IN list.
http://www.oracle-base.com/articles/misc/DynamicInLists.php
--
Regards,
Greg Rahn
http://structureddata.org
--
//www.freelists.org/webpage/oracle-l
Other related posts:
