skip to main content
Querying data stores with SQL : Supported data types : Oracle Sales Cloud data types
  

Try Now

Oracle Sales Cloud data types

The following table lists the Oracle Sales Cloud data types and their equivalents for JDBC and ODBC.
Table 163. Oracle Sales Cloud data types
Oracle Sales Cloud data type
JDBC data type
ODBC data type
BOOLEAN
BOOLEAN
SQL_BIT(-7)
DECIMAL
DECIMAL
SQL_DECIMAL(3)
INTEGER1
INTEGER or BIGINT or DECIMAL
SQL_INTEGER(4) or SQL_BIGINT(-5) or SQL_DECIMAL(3)
LONG
BIGINT
BIGINT (-5)
LONGSTRING
LONGVARCHAR
SQL_WLONGVARCHAR(-10) or SQL_LONGVARCHAR(-1)
STRING2
VARCHAR
SQL_VARCHAR(12)
1 When precision is less than or equal to 9, INTEGER is mapped as INTEGER for JDBC and SQL_INTEGER(4) for ODBC. When precision is greater than 9, INTEGER is mapped as BIGINT for JDBC and SQL_BIGINT(-5) for ODBC. When no precision is specified for JDBC, INTEGER is mapped as DECIMAL with a precision of 19 and a scale of 4. For ODBC, when no precision is specified, INTEGER is mapped as SQL_DECIMAL(3) with a precision of 19 and a scale of 4.

2 When no precision for STRING fields is offered in the metadata, STRING is mapped as VARCHAR with a length of 4000 characters for JDBC and SQL_VARCHAR(12) with a length of 4000 characters for ODBC. When precision for STRING columns is available, the precision is maintained and STRING is mapped as VARCHAR for JDBC and SQL_VARCHAR(12) for ODBC.