where JOB_ID IN (:JOB_ID)

Giganews Newsgroups
Subject: where JOB_ID IN (:JOB_ID)
Posted by:  probashi (probas…@hotmail.com)
Date: 5 Sep 2006

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

Replies