dBforums - View Single Post - Check PL/SQL var in an IF against a list of values returned from a SELECT?

MxC · #1 (**permalink**) 08-24-10, 06:54

In my PL/SQL code, I've a variable and I want to check if the value of this var is in a list of values. This list of values I want to get directly from a select statement. Can I do something like below:

Code:

IF (v_var1 in (select col1 from <table> where <condition>))
THEN
   <do something>
ELSE
   <do something else>
END IF;