Re: Cursor Parameter for "WHERE x IN..." or "WHERE x =...or x=..."
From: jane <janeyiu_at_optonline.net>
Date: Tue, 27 Nov 2001 17:34:25 GMT
Message-ID: <B8QM7.122265$636.16883708_at_news02.optonline.net>
Date: Tue, 27 Nov 2001 17:34:25 GMT
Message-ID: <B8QM7.122265$636.16883708_at_news02.optonline.net>
Never mind about "Dynamic SQL"...for query, it's only good for single-row return.
"jane" <janeyiu_at_optonline.net> wrote in message
news:QQPM7.121839$636.16858433_at_news02.optonline.net...
> SELECT * FROM EMP
> WHERE job IN.......
>
> SELECT * FROM EMP
> WHERE (job = x OR job = y....)
> --------------------------------------------------------------------------
--Received on Tue Nov 27 2001 - 18:34:25 CET
> -------
> Assuming you don't know how many elements to look for
> in WHERE at compile time...
> How would you pass parameter(s) to these cursors ?
> (assuming you use cursors)
> Dynamic SQL ?
>
> Thanks
> Jane
>
>