|
SQL> -- EXISTS
SQL> DECLARE
2 TYPE numberVarray IS VARRAY(5)OF NUMBER;
3
4 v_numarray numberVarray :=numberVarray(10,20,30,40,50);
5
6 BEGIN
7
8 IF v_numarray.EXISTS(4) THEN
9
10 DBMS_OUTPUT.PUT_LINE('The element 4 exists in the variable array.');
11
12 END IF;
13
14 END;
15 /
The element 4 exists in the variable array.
PL/SQL procedure successfully completed.
SQL>
SQL>
|