Explore the different datatype to catalog datatype mappings available for the datasource.
-
Default mapping
The tables lists the mapping datatype to catalog datatype, making data management simpler and more organized.
Table 1. Oracle datatype Catalog datatype BFILE blob BINARY_DOUBLE decimal BINARY_FLOAT decimal BLOB blob CHAR string CLOB string DATE datetime FLOAT(n) decimal LONG string LONG RAW blob NCHAR string NCLOB string NUMBER decimal NUMBER (p, s) decimal NVARCHAR2 string RAW blob TIMESTAMP datetime TIMESTAMP WITH LOCAL TIME ZONE datetime TIMESTAMP WITH TIME ZONE 4 datetime UROWID string VARCHAR2 string XMLType string -
Advanced connectivity bundle mapping
The tables lists the mapping from datatype to catalog datatype using advance connector bundle, making data management simpler and more organized. For configuration details, refer Advanced connectivity bundle.
Oracle datatype Catalog datatype AnyData string AnyDataSet string AnyType string BINARY_INTEGER integer BOOLEAN boolean CHAR VARYING string CHARACTER string CHARACTER VARYING string DBUriType string DEC decimal DECIMAL decimal DOUBLE PRECISION double HttpUriType string INT integer INTEGER integer JSON string LONG VARCHAR string MDSYS.SDO_Geometry geometry MDSYS.SDO_Georaster geospatial MLSLABEL string NATIONAL CHAR string NATIONAL CHAR VARYING string NATIONAL CHARACTER string NATIONAL CHARACTER VARYING string NATURAL string NATURALN string NCHAR VARYING string ORDAudio blob ORDDicom blob ORDDoc blob ORDImage blob ORDImageSignature blob ORDSYS.ORDAudio blob ORDSYS.ORDImage blob ORDSYS.ORDVideo blob ORDSYS.OrdImageSignature blob ORDVideo blob PERIOD time PLS_INTEGER decimal POSITIVE decimal POSITIVEN decimal RAW MLSLABEL blob REAL decimal ROWID string SDO_GeoRaster geospatial SDO_Geometry GEOMETRY SDO_Topo_Geometry GEOMETRY SIGNTYPE blob SI_AverageColor blob SI_Color blob SI_ColorHistogram blob SI_FeatureList blob SI_PositionalColor blob SI_StillImage blob SI_Texture blob SMALLINT integer STRING string SYS.AnyData string SYS.AnyDataSet string SYS.AnyType string SYS.DBUriType string SYS.HttpUriType string SYS.UriFactoryType string SYS.UriType string SYS.XMLType string UriType string VARCHAR string XDBUriType string