Re: Pass multiple numeric values to a function
- From: Michael Moore <michaeljmoore@xxxxxxxxx>
- To: ORACLE-L Freelists <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 13 Feb 2009 11:44:32 -0800
If you use a TABLE function, make sure you look at the Explain Plan. TABLE
functions are tricky for CBO and the resultant plan is sometimes really bad.
Mike
On Thu, Feb 12, 2009 at 5:47 PM, Greg Rahn <greg@xxxxxxxxxxxxxxxxxx> wrote:
> 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:
