Mega Code Archive

 

Categories / Oracle PLSQL / PL SQL

 

IN operator checks whether a variable value is in a set of comma-delimited values

SQL> SQL>  BEGIN   2    IF 1 IN (1,2,3) THEN   3     dbms_output.put_line('In the set.');   4    END IF;   5   END;   6   / In the set. PL/SQL procedure successfully completed.