DBMS_CLOUD Package ORC to Oracle Data Type Mapping
Describes the mapping of ORC data types to Oracle data types.
See DBMS_CLOUD Package Avro, ORC, and Parquet Complex Types for information on using ORC complex types.
| ORC Type | Oracle Type | More Information |
|---|---|---|
| array | VARCHAR2(n) JSON format | DBMS_CLOUD Package Avro, ORC, and Parquet Complex Types |
| bigint (64 bit) | NUMBER(19) | |
| binary | BLOB | |
| boolean (1 bit) | NUMBER(1) | |
| char | CHAR(n) | |
| date | DATE | |
| double | BINARY_DOUBLE | |
| float | BINARY_FLOAT | |
| int (32 bit) | NUMBER(10) | |
| list | VARCHAR2(n) JSON format | DBMS_CLOUD Package Avro, ORC, and Parquet Complex Types |
| map | VARCHAR2(n) JSON format | DBMS_CLOUD Package Avro, ORC, and Parquet Complex Types |
| smallint (16 bit) | NUMBER(5) | |
| string | VARCHAR2(4000) | |
| struct | VARCHAR2(n) JSON format | DBMS_CLOUD Package Avro, ORC, and Parquet Complex Types |
| timestamp | TIMESTAMP | |
| tinyint (8 bit) | NUMBER(3) | |
| union | VARCHAR2(n) JSON format | DBMS_CLOUD Package Avro, ORC, and Parquet Complex Types |
| varchar | VARCHAR2(n) |
Parent topic: DBMS_CLOUD Avro, ORC, and Parquet Support