Oracle Data Types: Complete Guide

1 year ago
Emily Johnson
1 minute

Oracle database supports various data types such as:

  1. Character data types: CHAR, VARCHAR2, NCHAR, NVARCHAR2, LONG, RAW, LONG RAW, CLOB, NCLOB, BLOB.
  2. Numeric data types such as NUMBER, FLOAT, BINARY_FLOAT, and BINARY_DOUBLE.
  3. Types of data related to dates and times include DATE, TIMESTAMP, TIMESTAMP WITH TIME ZONE, TIMESTAMP WITH LOCAL TIME ZONE, INTERVAL YEAR TO MONTH, and INTERVAL DAY TO SECOND.
  4. Binary data types: BLOB, RAW, LONG RAW
  5. Large object data types: CLOB, NCLOB
  6. Identifier types for rows: ROWID, UROWID.
  7. Data type for XML: XMLType
  8. Collection data types: VARRAY, Nested Table
  9. Other data types: BOOLEAN, BFILE.

In addition to the listed data types, Oracle database also supports User-Defined Types, allowing users to define their own data types as needed.

bannerAds