CARDINALITY table collection
SQL> CREATE OR REPLACE PROCEDURE cardinality_example AS
2 TYPE charTable IS TABLE OF VARCHAR2(10);
3 emp1 charTable;
4 cardinality_var INTEGER;
5 BEGIN
6 emp1 := charTable('A', 'B', 'C');
7 cardinality_var := CARDINALITY(emp1);
8 DBMS_OUTPUT.PUT_LINE('cardinality_var = ' || cardinality_var);
9 END cardinality_example;
10 /
Procedure created.
SQL>
Related examples in the same category