Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Where ... in clause with parameter

chrissy2Aug 9 2007 — edited Mar 21 2008
Hi,

I'm having a small problem with my where clause.

I have the following select statement

select *
from emp
where empno in (:par)

I want to set a comma separated list as :par, something like '7839,7698,7782'.
But this is not working.
How do I get this select working?

Thanks
chrissy
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 18 2008
Added on Aug 9 2007
22 comments
5,611 views