Oracle Data Type-3, oracle-3
9. TIMESTAMP WITH TIME ZONE
It contains all fields in the TIMESTAMP data type. In addition, it also contains two additional fields: timezone_hour and timezone_minute. This data type contains information about supported time zones. This data type can be used in the Oracle9i database and its updated version.
10. TIMESTAMP WITH LOCAL TIME ZONE
Except that the time zones stored in the database are standardized, other fields are the same as those in the TIMESTAMP data type. When selecting a column, the date/time 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
It is used to store a time period, which consists of months and years. 5B is required for storage. This data type can be used in the Oracle9i database and its updated version.
12. INTERVAL DAY TO SECOND
It is used to store a time period, which consists 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
Stores raw binary data. You can store up to 2000B of data. We recommend that you use BLOB instead. For example:
14. LONG RAW
Stores raw binary data. You can store up to 2 GB of data. We recommend that you use BLOB instead. For example:
15. ROWID
The ROWID string in the table. This data type is used to store the returned values of pseudo columns of the ROWID type. For example:
16. UROWID
Indicates the logical row address in the index organization table. For example:
17. CLOB
It is used to store character-based large objects. A maximum of 4 GB of data can be stored in the Oracle9i database, which is larger than the maximum data that can be stored in the Oracle10g Database. This is also a factor that determines the block size of the database (~ 4 GB * data block size ).