Defining Your Own Datatypes : Subtype Custom Type « PL SQL Data Types « Oracle PL/SQL Tutorial

1. Oracle PL/SQL Tutorial
2. PL SQL Data Types
3. Subtype Custom Type

You can create PL/SQL datatypes in the declaration portions of procedures, functions, root anonymous blocks, package bodies, and package specs.

You create SQL types by using a DDL operation with the following syntax:

type newType is definitionOfTheType;

The basic syntax is shown here:

declare
   type newType is definitionOfTheType;