Skip to Main Content

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!

Using multiple values in IN condition of SQL Query at run time.

SureshMSep 16 2015 — edited Sep 17 2015

Hi,

I have requirement in which I have to use multiple values in IN condition at run time.

For eg: I am storing multiple values in a variable and that variable I want to pass in the IN condition but if i used variable the query is going into error. At run time the values keep changing in the variable.

v_temp = '712,713';

select * from temp

where column in (v_temp);

Please help.

Thanks,

Suresh

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 15 2015
Added on Sep 16 2015
15 comments
2,565 views