IN operator checks whether a variable value is in a set of comma-delimited values. : IN « PL SQL « Oracle PL / SQL






  1. Oracle PL / SQL
  2. PL SQL
  3. IN

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.








Related examples in the same category

1.Use IN operator in procedure
2.IN operator in PL SQL
3.IN/NOT IN example(table collection)
4.NOT IN example (table collection)