compare table of varchar2 : Table of Varchar2 « Collections « Oracle PL/SQL Tutorial

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

SQL>
SQL> DECLARE
  2     TYPE clientList IS TABLE OF VARCHAR2 (64);
  3
  4     group1   clientList := clientList ('Customer 1', 'Customer 2');
  5     group2   clientList := clientList ('Customer 1', 'Customer 3', NULL);
  6     group3   clientList := clientList ('Customer 3', NULL, 'Customer 1');
  7  BEGIN
  8     IF group1 = group2
  9     THEN
 10        DBMS_OUTPUT.put_line ('Group 1 = Group 2');
 11     ELSIF group1 != group2
 12     THEN
 13        DBMS_OUTPUT.put_line ('Group 1 != Group 2');
 14     END IF;
 15
 16     IF group2 != group3
 17     THEN
 18        DBMS_OUTPUT.put_line ('Group 2 != Group 3');
 19     ELSIF group2 = group3
 20     THEN
 21        DBMS_OUTPUT.put_line ('Group 2 = Group 3');
 22     END IF;
 23  END;
 24  /

PL/SQL procedure successfully completed.