May 12

Oracle Sub Types for Data Types: Exception Block

An unconstrained subtype has the same set of values as its base type, so it is only another name for the base type.

Syntax:

SUBTYPE subtype_name IS base_type
Example:
 
SUBTYPE "DOUBLE PRECISION" IS FLOAT
SUBTYPE Balance IS NUMBER;


Constrained SubType


 


SUBTYPE Balance IS NUMBER(8,2);


Oracle Exception Block Example:






Ref: https://docs.oracle.com/cd/B13789_01/appdev.101/b10807/07_errs.htm