Oracle Cloud Infrastructure Documentation

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) or VARCHAR2(32767)

Depending on the value of the format parameter option maxvarchar and on the MAX_STRING_SIZE value. See DBMS_CLOUD Package Format Options for Avro, ORC, or Parquet for more information.

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)