where JOB_ID IN (:JOB_ID)

Hi,

When I run q1 I get back 10 rows but when I run q2 (whit supplying "'IT_PROG', 'FI_ACCOUNT'" in the parameter) I got zero records back.

Can any body explain this!!!.

--q1:

select * from HR.EMPLOYEES where JOB_ID IN ('IT_PROG', 'FI_ACCOUNT')

--q2

select * from HR.EMPLOYEES where JOB_ID IN (:JOB_ID)

Thanks Received on Tue Sep 05 2006 - 13:04:34 CDT