Create a constrained subtype DB_STRING : subtype « PL SQL « Oracle PL / SQL






Create a constrained subtype DB_STRING

    
SQL>
SQL> DECLARE
  2    SUBTYPE db_string IS VARCHAR2(4000 BYTE);
  3    c VARCHAR2(1 CHAR) := 'A';
  4    d DB_STRING;
  5  BEGIN
  6    d := c;
  7  END;
  8  /

PL/SQL procedure successfully completed.

SQL>
SQL>

   
    
    
    
  








Related examples in the same category

1.Creates and uses a constrained subtype CODE