Using the EXISTS method : Table of Number « Collections « Oracle PL/SQL Tutorial

1. Oracle PL/SQL Tutorial
2. Collections
3. Table of Number

SQL> DECLARE
  2    TYPE numberTabletype IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
  3    myTable numberTabletype;
  4    v_num NUMBER :=13;
  5  BEGIN
  6    myTable(1):=1001;
  7
  8    myTable(10):=1002;
  9
 10    myTable(-10):=1003;
 11
 12    myTable(v_num):=1004;
 13
 14    IF myTable.EXISTS(100) THEN
 15      dbms_output.put_line(to_char(myTable(100)));
 16    END IF;
 17
 18  END;
 19  /

PL/SQL procedure successfully completed.