Cursor Parameter for "WHERE x IN..." or "WHERE x =...or x=..."
From: jane <janeyiu_at_optonline.net>
Date: Tue, 27 Nov 2001 17:13:20 GMT
Message-ID: <QQPM7.121839$636.16858433_at_news02.optonline.net>
SELECT * FROM EMP
[Quoted] WHERE job IN.......
[Quoted] 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 ?
Date: Tue, 27 Nov 2001 17:13:20 GMT
Message-ID: <QQPM7.121839$636.16858433_at_news02.optonline.net>
SELECT * FROM EMP
[Quoted] WHERE job IN.......
SELECT * FROM EMP
WHERE (job = x OR job = y....)
[Quoted] 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 - 18:13:20 CET