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!

If condition in a variable

User_0QUXCOct 7 2021

How can I use a variable istead of this hard-coded values in an IF-statement?
IF my_type IN ('1','2','3', 'X') THEN
This doesn't work
IF l_i.provstty_stavtyp IN (l_types) THEN
l_types looks like this: '1','2','3','X'

This post has been answered by BluShadow on Oct 7 2021
Jump to Answer
Comments
Post Details
Added on Oct 7 2021
4 comments
1,404 views