CARDINALITY table collection : CARDINALITY « PL SQL « Oracle PL / SQL






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

1.CARDINALITY operator lets count the elements in a collection.
2.Count only the unique values by combining the CARDINALITY and SET operators