Creates and uses a constrained subtype CODE : subtype « PL SQL « Oracle PL / SQL

1. Oracle PL / SQL
2. PL SQL
3. subtype

Creates and uses a constrained subtype CODE

    
SQL>
SQL> DECLARE
  2    SUBTYPE code IS CHAR(1 CHAR);
  3    c CHAR(1 CHAR) := 'A';
  4    d CODE;
  5  BEGIN
  6    d := c;
  7  END;
  8  /

PL/SQL procedure successfully completed.

SQL>

   
    
    
    
  

Related examples in the same category