Oracle Data Types

Two general types of data are found in the Oracle database: built-in data types and user-defined data types. This section provides an explanation of both types and the kinds of data associated with each.

User-Defined Data Types

Oracle supports the ability for users to define their own abstract data types and use them within the application. For example, you could define an address type as including street_address1, street_address2, city, state, country, and zip_code and use that type in tables as a single entity rather than as each individual piece. If you always reference addresses in the same way, this can ease coding and facilitate reuse.

Built-In Data Types

Oracle provides several built-in data types to store scalar data, ...

Get Oracle 9i Fundamentals I Exam Cram™ 2 (Exam 1Z0-031) now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.