Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / PL SQL Data Types

 

Defining Your Own Datatypes

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;