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.
|