Oracle Datatype Mapping
  • 1 Minute to read
  • Dark
    Light
  • PDF

Oracle Datatype Mapping

  • Dark
    Light
  • PDF

Type Mapping

We match Oracle data types to Rivery data types while extracting your data. If a data type is not supported, we will map it as a String type.

The following table shows the mapping of Oracle data types to Rivery-compatible types:

Oracle Type Rivery Type
BLOB STRING
DATE TIMESTAMP
TIMESTAMP TIMESTAMP
VARCHAR STRING
NVARCHAR STRING
CHAR STRING
FLOAT FLOAT
CLOB STRING
DOUBLE_PRECISION FLOAT
INTERVAL TIMESTAMP
LONG INTEGER
NCLOB STRING
NUMBER FLOAT
RAW STRING
ROWID INTEGER
VARCHAR2 STRING
NVARCHAR2 STRING

Was this article helpful?