Oracle Data Type-3

9. TIMESTAMP with Time ZONE
Contains all the fields in the TIMESTAMP data type, plus two additional fields: Timezone_hour and Timezone_minute. This data type contains information about the time zone that is supported. This data type can be used in the Oracle9i database and its updated version.

10. TIMESTAMP with LOCAL time ZONE
In addition to standardizing the time zone that is stored in the database, the other fields that are contained are the same as those in the TIMESTAMP data type. When you select a column, the date/time standard is the time zone of the session. This data type can be used in the Oracle9i database and its updated version.

11. INTERVAL Year to MONTH
Used to store a time period consisting of months and years. Requires 5 B to store. This data type can be used in the Oracle9i database and its updated version.

12, INTERVAL Day to SECOND
Used to store a time period, consisting of days and seconds. 11B is required for storage. This data type can be used in the Oracle9i database and its updated version.

13. RAW
Used to store binary data of the raw type. You can store up to 2000B. It is recommended to use BLOBs instead. For example:
14, LONG RAW
Used to store binary data of the raw type. You can store up to 2GB of data. It is recommended to use BLOBs instead. For example:
15, ROWID
A string representation of the ROWID type in the table. Use this data type to store the return value of a pseudo-column of type ROWID. For example:
16, Urowid
Represents a logical line address in an indexed organization table. For example:
17, CLOB
Used to store large-character-based objects. It is possible to store up to 4GB of data in the Oracle9i database, which is larger than the maximum amount of data that can be stored in the ORACLE10G database, which is also a factor in the size of the database that is now specified (~4gb* block size).

Oracle Data Type-3