IN operator in PL SQL : IN « PL SQL « Oracle PL / SQL

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

IN operator in PL SQL

   
SQL>
SQL> set serveroutput on
SQL>
SQL>
SQL> DECLARE
  2     lv_test_bln BOOLEAN;
  3  BEGIN
  4     lv_test_bln := UPPER('AAA') IN ('TRE','B','N');
  5     IF lv_test_bln THEN
  6        DBMS_OUTPUT.PUT_LINE('Result: TRUE');
  7     ELSE
  8        DBMS_OUTPUT.PUT_LINE('Result: FALSE');
  9     END IF;
 10  END;
 11  /
Result: FALSE

PL/SQL procedure successfully completed.

   
    
  

Related examples in the same category