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, ...