Database Reference
In-Depth Information
Figure 24.5
Using a Package to
Group Procedures.
24.3
Variables and Datatypes in PL/SQL
PL/SQL contains all of the predefined datatypes included in SQL, as
explained in Chapter 16, plus some additional datatypes. Some of these
additional datatypes are listed as follows:
NUMBER Datatypes
. There are numerous NUMBER subtypes
provided for ANSI standard compliance. These subtypes will all con-
vert to NUMBER or FLOAT datatypes both for Oracle table col-
umns and internally in PL/SQL. For example, INTEGER and
SMALLINT.
BINARY_INTEGER
. Stores a signed integer value. There are various
subtypes.
BOOLEAN
. Stores a TRUE, FALSE, or null value.
RECORD
. Composite structure similar to a VARRAY or TABLE
datatype allowing the creation of a table row structure in memory.
The following line uses ROWTYPE to duplicate the column struc-
ture of an ARTIST table row into the RECORD called RARTIST.
