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