Re: SELECT Question
From: gazzag <gareth_at_jamms.org>
Date: Tue, 17 Jun 2008 09:35:02 -0700 (PDT)
Message-ID: <d4eb97aa-40e8-468d-b9e7-df0451a39d69@x41g2000hsb.googlegroups.com>
Date: Tue, 17 Jun 2008 09:35:02 -0700 (PDT)
Message-ID: <d4eb97aa-40e8-468d-b9e7-df0451a39d69@x41g2000hsb.googlegroups.com>
On 17 Jun, 17:27, Mtek <m..._at_mtekusa.com> wrote:
> Hi,
>
> 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?
>
> Thanks!
>
> John
Look into EXECUTE IMMEDIATE and wave scalability goodbye :)
-g Received on Tue Jun 17 2008 - 11:35:02 CDT