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@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:13:20 CST