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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

comma separated values in where clause

jaijeevaApr 17 2015 — edited Apr 17 2015

Hi Guys,

I'm sending in a comma delimited parameter value to a stored procedure in Oracle. The parameter goes to a WHERE clause, I'm trying to achieve something like this:

v_topupid = "ABC123, ABC456, ABC789"  SELECT * FROM Tbl1 WHERE topup_id IN (v_topupid)

Problem is the select statement does not recognize the commas in between the values, it takes it as a single string so when the stored procedure is executed it returns no values.

instead of regexp_substr function any option will be here Please help me out.

Locked Post

New comments cannot be posted to this locked post.

Locked on May 15 2015

Added on Apr 17 2015

3 comments

1,637 views