Re: SELECT Question
Date: Tue, 17 Jun 2008 18:40:14 +0200
"gazzag" <gareth_at_jamms.org> schreef in bericht
On 17 Jun, 17:27, Mtek <m..._at_mtekusa.com> wrote:
> Quick question here, if I have a WHERE clause with an IN condition -
> WHERE var IN (1, 2, 3)......
> What if the list is dynamic? How would you do that? The column in
> the table is numeric. Do I have to 'build' the select statement?
Look into EXECUTE IMMEDIATE and wave scalability goodbye :)
Or write a function returning 1 if the value is ok, 0 if not and use
where your_function(var) = 1;
You can't build an index on it, though (not even function based, because the function is not deterministic)
Shakespeare Received on Tue Jun 17 2008 - 11:40:14 CDT