Check PL/SQL var in an IF against a list of values returned from a SELECT?

MxC · #1 (**permalink**) 08-24-10, 07: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;

magicwand · #2 (**permalink**) 08-24-10, 09:48

Code:

declare
  vIntResult     pls_integer := 0;
begin
  select 1 
  into   vIntResult 
  from   <table> 
  where  v_var1 = <col1> 
  and    <other_conditions>;
  
  if vIntResult = 1
     then
        <do something>
     else
        <do something else>
  end if;

n_i · #3 (**permalink**) 08-24-10, 10:22

Quote:

Originally Posted by MxC

Code:

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

Code:

IF EXISTS (select 1 from <table> where <condition>  and col1 = v_var1 )
THEN
   <do something>
ELSE
   <do something else>
END IF;

?

MxC · #4 (**permalink**) 08-30-10, 07:07

My apologies if I couldn't thank all of you for the various solutions presented. They have helped me quite a bit.

Thanks to all of you!

Internet Services

Web Development

Digital Marketing

Consumer Tech