Re: SELECT Question

From: <sybrandb_at_hccnet.nl>
Date: Tue, 17 Jun 2008 21:37:08 +0200
Message-ID: <3h4g545jvurngrsulcom40slcra1vmji7j@4ax.com>


On Tue, 17 Jun 2008 09:27:11 -0700 (PDT), Mtek <mtek_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

Go to http://asktom.oracle.com, and search for 'dynamic IN list'  

-- 
Sybrand Bakker
Senior Oracle DBA
Received on Tue Jun 17 2008 - 14:37:08 CDT

Original text of this message