SqlDBM Help Center

All CollectionsDatabase 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 year ago

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

Objects and properties

Schemas
Tables
- Constraints
  - PK
  - FK
  - AK (UNIQUE)
  - CHECK
    Disable
    Expression
- 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: