Re: Pass multiple numeric values to a function
From: Greg Rahn <greg_at_structureddata.org>
Date: Thu, 12 Feb 2009 17:47:47 -0800
Message-ID: <a9c093440902121747y12e677bfjf5ed59109f8eb4fd_at_mail.gmail.com>
On Thu, Feb 12, 2009 at 11:29 AM, Ravi Gaur <ravigaur1_at_gmail.com> 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.
Date: Thu, 12 Feb 2009 17:47:47 -0800
Message-ID: <a9c093440902121747y12e677bfjf5ed59109f8eb4fd_at_mail.gmail.com>
On Thu, Feb 12, 2009 at 11:29 AM, Ravi Gaur <ravigaur1_at_gmail.com> 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 -- http://www.freelists.org/webpage/oracle-lReceived on Thu Feb 12 2009 - 19:47:47 CST