MULTISET UNION table collection : MULTISET « PL SQL « Oracle PL / SQL






MULTISET UNION table collection

 


SQL> CREATE OR REPLACE PROCEDURE multiset_example AS
  2    TYPE charTable IS TABLE OF VARCHAR2(10);
  3    emp1 charTable;
  4    emp2 charTable;
  5    emp3 charTable;
  6    count_var INTEGER;
  7  BEGIN
  8    emp1 := charTable('A', 'B', 'C');
  9    emp2 := charTable('D', 'E', 'F');
 10
 11    emp3 := emp1 MULTISET UNION emp2;
 12    DBMS_OUTPUT.PUT('UNION: ');
 13    FOR count_var IN 1..emp3.COUNT LOOP
 14      DBMS_OUTPUT.PUT(emp3(count_var) || ' ');
 15    END LOOP;
 16    DBMS_OUTPUT.PUT_LINE(' ');
 17
 18
 19  END multiset_example;
 20  /

Procedure created.

   
  








Related examples in the same category

1.MULTISET EXCEPT operator finds the elements remaining from the first set after removing any matching elements from the second set
2.MULTISET EXCEPT table collection
3.MULTISET INTERSECT operator finds the intersection or matching values between two sets
4.MULTISET INTERSECT table collection
5.MULTISET UNION DISTINCT table collection
6.MULTISET UNION operator performs a UNION ALL operation on two collections