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....)
> --------------------------------------------------------------------------
--
> -------
> 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
>
>
Received on Tue Nov 27 2001 - 11:34:25 CST
