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!

Input String to be coated

User_W65WSJun 19 2020 — edited Jun 22 2020

Hi All,

I have a requirement where user will put multiple strings with COMMA and without single quotes e.g.

orgcode

29A, 27B, 238C, 455VV

Now these are four different strings, I want to pass them in Oracle SQL IN statement as follow:

SELECT * from TABLE1 WHERE orgcode IN ('29A', '27B', '238C', '455VV');

My question is how can I easily put orgcode with quoted strings as shown above.

Thanks

This post has been answered by odie_63 on Jun 20 2020

Jump to Answer

Added on Jun 19 2020

10 comments

575 views