Next: Control Structures
Up: Implementation Environment
Previous: Main Features
Following is a list of a few of the simple data types handled by PL/SQL.
- fixed size types: number, boolean, date, rowid, mlslabel, and
- variable size types: chars, varchar2, rawdata.
Apart from the simple data types, PL/SQL also allows record and table types.
One can define a record or a table type in the following way.
Then the type_name defined can be used to declare variables of
these record or table types. NOT NULL is used to specify if the
table accepts only non null values. INDEX BY BINARY_INTEGER
is used to declare tables that can be accessed by an integer index, as in
one dimensional arrays of Pascal.
Punit Bhargava
Wed Mar 11 18:50:53 PST 1998