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

Oracle Datatype Mapping

  • Dark
    Light
  • PDF

Article summary

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 TypeRivery Type
BLOBSTRING
DATETIMESTAMP
TIMESTAMPTIMESTAMP
VARCHARSTRING
NVARCHARSTRING
CHARSTRING
FLOATFLOAT
CLOBSTRING
DOUBLE_PRECISIONFLOAT
INTERVALTIMESTAMP
LONGINTEGER
NCLOBSTRING
NUMBERFLOAT
RAWSTRING
ROWIDINTEGER
VARCHAR2STRING
NVARCHAR2STRING

Was this article helpful?

What's Next