Oracle Supported Data Types:
The Oracle8 database gives support for two distinct kinds of data: -
- BUILT-IN DATA TYPES
- USER DEFINED DATA TYPES
It is already been discussed that Built-In Datatypes supported in Oracle.
Object Option
The objects option makes Oracle an object-relational database management system (ORDBMS), that means which users can describes additional categories of data-specifying both the structure of the data and the ways of operating on it-and use these kind within the relational model. That approach adds value to the data stored in a database.
An Oracle with the objects option stores structured business data in its natural form and permits applications to retrieve it that way. For this reason it works efficiently with applications established using object-oriented programming methods.
An Oracle's support for user-defined datatypes makes it simpler for application developers to work with complex data like audio, Images, and video.