NOT IN example (table collection)
SQL> CREATE OR REPLACE PROCEDURE in_example AS
2 TYPE charTable IS TABLE OF VARCHAR2(10);
3 emp1 charTable;
4 emp2 charTable;
5 emp3 charTable;
6 result BOOLEAN;
7 BEGIN
8 emp1 := charTable('A', 'B', 'C');
9 emp2 := charTable('C', 'D', 'E');
10 emp3 := charTable('A', 'B', 'C');
11
12
13
14 result := emp3 NOT IN (emp2);
15 IF result THEN
16 DBMS_OUTPUT.PUT_LINE('emp3 not in emp2');
17 END IF;
18 END in_example;
19 /
Procedure created.
SQL>
Related examples in the same category