Live ORACLE

DECLARE

  TYPE dnames_tab IS TABLE OF VARCHAR2(30);

   dept_names1  DNAMES_TAB := Dnames_tab('Shipping','Sales','Finance','Payroll');

   dept_names2  DNAMES_TAB := Dnames_tab('Sales','Finance','Shipping','Payroll');

   dept_names3  DNAMES_TAB := Dnames_tab('Sales','Finance','Payroll');

BEGIN

  -- We can use = or !=, but not <>.

  -- Notice that these 2 are equal even though the members are in different order.

  IF dept_names1 = dept_names2 THEN

    dbms_output.Put_line('dept_names1 and dept_names2 have the same members.');

  END IF;

 

  IF dept_names2 != dept_names3 THEN

    dbms_output.Put_line('dept_names2 and dept_names3 have different members.');

  END IF;

END;

/

Comparing Two Nested Tables