Menu

Oracle Data Types.

Oracle supports various data types, and this page provides a compilation of commonly used data types in Oracle.

  1. BFILE

    Oracle BFILE data type is a special data type in the Oracle database used for handling binary file data.

  2. BINARY_DOUBLE

    Oracle BINARY_DOUBLE is a data type used in Oracle databases to store double-precision floating-point numbers.

  3. BINARY_FLOAT

    Oracle BINARY_FLOAT is a data type used in Oracle databases to store single-precision floating-point numbers.

  4. BLOB

    Oracle BLOB is a binary large object data type used to store binary data such as images, audio, videos, etc.

  5. BOOLEAN

    The BOOLEAN data type in Oracle is a logical type used to represent one of two values: true or false.

  6. CHAR

    The Oracle CHAR data type is used to store fixed-length strings.

  7. CLOB

    The Oracle CLOB data type is used to store large amounts of text data.

  8. DATE

    In Oracle database, DATE is a data type used to store date and time information.

  9. INTERVAL DAY TO SECOND

    Oracle INTERVAL DAY TO SECOND stores durations in days through fractional seconds. Learn syntax, default day precision 2, default fractional-second precision 6, arithmetic, and conversion.

  10. INTERVAL YEAR TO MONTH

    In Oracle database, the INTERVAL YEAR TO MONTH data type is used to represent the time interval between two dates or times in years and months.

  11. Introduction to Oracle NULL Data Type

    In Oracle database, NULL is a special data type that represents a missing or unknown value.

  12. JSON

    Oracle JSON data type can store and manipulate data in JSON format

  13. NCHAR

    In Oracle Database, NCHAR is a character data type used to store fixed-length strings in the Unicode character set.

  14. NCLOB

    In Oracle database, the NCLOB data type is used to store large amounts of character data in Unicode character set, with a maximum length of 4GB.

  15. NESTED TABLE

    Oracle NESTED TABLE data type is a type of nested table that can store another table within a table.

  16. NUMBER

    The NUMBER data type is a fundamental data type in the Oracle database used to represent numerical data.

  17. NVARCHAR2

    In Oracle database, NVARCHAR2 is a variable-length string data type that stores Unicode characters.

  18. OBJECT

    In the Oracle database, OBJECT is a composite data type that can be used to define a custom data type with multiple attributes.

  19. REF

    Oracle REF stores a logical reference to a row object of an object type. Learn REF columns, object tables, REF(), DEREF(), SCOPE, and dangling references.

  20. ROWID

    In Oracle database, the ROWID data type is a special data type used to identify a row in a table.

  21. TIMESTAMP

    The Oracle TIMESTAMP data type is a data type used for storing dates and times.

  22. TIMESTAMP WITH LOCAL TIME ZONE

    Learn how Oracle TIMESTAMP WITH LOCAL TIME ZONE normalizes values to DBTIMEZONE, displays them in SESSIONTIMEZONE, and interacts with CAST and SYS_EXTRACT_UTC.

  23. TIMESTAMP WITH TIME ZONE

    Oracle TIMESTAMP WITH TIME ZONE stores a timestamp with explicit time-zone information. Learn precision, offsets, region names, UTC comparison behavior, and AT TIME ZONE examples.

  24. UROWID

    In Oracle, UROWID is a special data type used to store unique row identifiers.

  25. VARCHAR2

    In Oracle Database, VARCHAR2 is a data type used to store variable-length strings, with a maximum length of 4000 bytes.

  26. VARRAY TYPE

    The Oracle VARRAY data type is a composite data type used for storing arrays of variable length.

  27. XMLTYPE

    In Oracle Database, XMLTYPE is a very useful data type that can be used to store and manipulate XML documents.