TABLE.Exist : Associative Arrays « Collections « Oracle PL/SQL Tutorial

1. Oracle PL/SQL Tutorial
2. Collections
3. Associative Arrays

SQL>
SQL>
SQL> SET ECHO ON
SQL> SET SERVEROUTPUT ON
SQL>
SQL> DECLARE
  2      --Define an index-by table type.
  3      TYPE num_table IS TABLE OF NUMBER
  4                     INDEX BY BINARY_INTEGER;
  5
  6      nums num_table;
  7      some_num NUMBER;
  8  BEGIN
  9      nums(10) := 11;
 10
 11      IF nums.EXISTS(11) THEN
 12          some_num := nums(11);
 13      ELSE
 14          DBMS_OUTPUT.PUT_LINE('Element 11 still does not exist.');
 15      END IF;
 16
 17  END;
 18  /
Element 11 still does not exist.

PL/SQL procedure successfully completed.

SQL>