Appendix A. Datatypes

The datatype is one of the attributes for a column in a table or for a variable in a stored procedure. A datatype describes and limits the type of information stored in a column, as well as some of the operations that you can perform on that column.

You can logically divide Oracle datatype support into two categories—scalar datatypes (datatypes that return a single value) and collection datatypes (datatypes that hold or point to a collection of data). PL/SQL also supports reference datatypes that contain pointers to other objects.

Get Oracle in a Nutshell now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.