PL/SQL Example Using SUBTYPE and VALUE_ERROR

(Andrew Reid) This example was tested on Oracle 11.2. First it creates a single-digit variable called SMALL_NUMBER. It then uses this to define a subtype called SINGLE_DIGIT, which has the same type as SMALL_NUMBER.

Read More - Register for Free Membership