All Collections
Database Object and Feature Support
Oracle Support Summary
Oracle Support Summary

Oracle object and data type support summary

S
Written by Serge Gershkovich
Updated over a week ago

This article summarizes the features, objects, properties, and data types that are available for Oracle projects.

Objects and properties

  • Schemas

  • Tables

    • Constraints

    • INDEX

      • Columns

      • Expression

      • Visible / Invisible

      • Sort / Nosort

      • Usable / Unusable

    • UNIQUE INDEX

      • Columns

      • Expression

      • Visible / Invisible

      • Sort / Nosort

      • Usable / Unusable

    • BITMAP INDEX

      • Columns

      • Expression

      • Visible / Invisible

      • Sort / Nosort

      • Usable / Unusable

    • Comment/Description

    • Post Script

  • Columns

    • Data type (see summary of types below)

    • (NOT) NULL

    • Visible / Invisible

    • Default

    • Identity

      • Generated

        • Always

        • ByDefault

        • ByDefaultOnNull

      • Start

        • Limit

      • Increment

      • Cache

        • NoCache

      • Min

        • NoMin

      • Max

        • NoMax

      • Order

        • NoOrder

      • Cycle

        • NoCycle

    • Sequence

    • Collation

    • Comment/Description

  • Sequences

    • Starts with

    • Increment by

    • Cache

      • NoCache

    • Min

      • NoMin

    • Max

      • NoMax

    • Order

      • NoOrder

    • Cycle

      • NoCycle

Data types

  • Numeric Data Types

    • NUMBER

    • INT

    • FLOAT

    • BINARY_FLOAT

    • BINARY_DOUBLE

  • String & Binary Data Types

    • CHAR

    • NCHAR

    • NVARCHAR2

    • VARCHAR2

    • BLOB

    • CLOB

    • NCLOB

    • BFILE

  • Date & Time Data Types

    • DATE

    • INTERVAL

    • INTERVAL DAY TO SECOND

    • INTERVAL YEAR TO MONTH

    • TIMESTAMP

    • TIMESTAMP WITH TIMEZONE

    • TIMESTAMP WITH LOCAL TIMEZONE

See also:

Did this answer your question?