The Oracle data type is one of the fundamental concepts of the database. Every element, or piece of data in the database, has its own basic behavioral pattern, which is known as data type. An element can be numeric, string, periodic, Boolean or large object. Scalar data types are the original data types which are not derivatives of any other types. Scalar data types constitute a family of base types and their subtypes.
PL/SQL is open to all categories of SQL data types. In addition to available SQL data types, PL/SQL maintains its own data types, most of which are subtypes of SQL data types. We will extend our discussion on these subtypes now.
The following table shows the base types and subtypes under each scalar data types:
|
Number |
Character |
Date/Time |
Boolean |
|---|---|---|---|
|
|
|
|
|
|
|
|
| |
|
|
|
| |
|
|
| ||
|
|
| ||
|
|
| ||
|
|
| ||
|
|