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!

using parameter in contains oracle sql.

adrinaAug 15 2016 — edited Aug 15 2016

Hi,

Am using oracle 11g.

Am trying to use the below query but it showing the result.

select main_item_code from store_transaction_items where main_item_code in (:pmain);

Am passing the value as '000138','000013' to variable pmain.

The below query is getting the result

select main_item_code from store_transaction_items where main_item_code in ('000138','000013');

Kindly suggest
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 12 2016
Added on Aug 15 2016
3 comments
666 views