SET(table collection) : Set « PL SQL « Oracle PL / SQL






SET(table collection)

    
SQL> CREATE OR REPLACE PROCEDURE set_example AS
  2    TYPE charTable IS TABLE OF VARCHAR2(10);
  3    emp1 charTable;
  4    emp2 charTable;
  5    count_var INTEGER;
  6  BEGIN
  7    emp1 := charTable('A', 'B', 'C', 'S');
  8    emp2 := SET(emp1);
  9    DBMS_OUTPUT.PUT('emp2: ');
 10    FOR count_var IN 1..emp2.COUNT LOOP
 11      DBMS_OUTPUT.PUT(emp2(count_var) || ' ');
 12    END LOOP;
 13    DBMS_OUTPUT.PUT_LINE(' ');
 14  END set_example;
 15  /

Procedure created.

   
    
    
    
  








Related examples in the same category

1.SET operator removes any duplicates from the set and returns a new set with unique values