Oracle Datatype Mapping
- 1 Minute to read
- Print
- DarkLight
- PDF
Oracle Datatype Mapping
- 1 Minute to read
- Print
- DarkLight
- PDF
Article summary
Did you find this summary helpful?
Thank you for your feedback
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?