skip to main content
Reference : getTypeInfo()
  

Try DataDirect Drivers Now

getTypeInfo()

The DatabaseMetaData.getTypeInfo() method returns information about data types. The following table provides getTypeInfo() results for all sources supported by the Oracle Service Cloud driver.
Table 16. getTypeInfo() Results
TYPE_NAME = BASE_64_BINARY
AUTO_INCREMENT = false
CASE_SENSITIVE = false
CREATE_PARAMS = null
DATA_TYPE = -4
FIXED_PREC_SCALE = false
LITERAL_PREFIX = '
LITERAL_SUFFIX = '
LOCAL_TYPE_NAME = BASE_64_BINARY
MAXIMUM_SCALE = null
 
MINIMUM_SCALE = null
NULLABLE = 1
NUM_PREC_RADIX = null
PRECISION = 2147483647
SEARCHABLE = 0
SQL_DATA_TYPE = null
SQL_DATETIME_SUB = null
UNSIGNED_ATTRIBUTE = null
TYPE_NAME = BOOLEAN
AUTO_INCREMENT = false
CASE_SENSITIVE = false
CREATE_PARAMS = null
DATA_TYPE = 16
FIXED_PREC_SCALE = false
LITERAL_PREFIX = null
LITERAL_SUFFIX = null
LOCAL_TYPE_NAME = BOOLEAN
MAXIMUM_SCALE = null
 
MINIMUM_SCALE = null
NULLABLE = 1
NUM_PREC_RADIX = null
PRECISION = 1
SEARCHABLE = 3
SQL_DATA_TYPE = null
SQL_DATETIME_SUB = null
UNSIGNED_ATTRIBUTE = null
TYPE_NAME = DATE
AUTO_INCREMENT = false
CASE_SENSITIVE = false
CREATE_PARAMS = null
DATA_TYPE = 91
FIXED_PREC_SCALE = false
LITERAL_PREFIX = '
LITERAL_SUFFIX = '
LOCAL_TYPE_NAME = DATE
MAXIMUM_SCALE = null
 
MINIMUM_SCALE = null
NULLABLE = 1
NUM_PREC_RADIX = null
PRECISION = 10
SEARCHABLE = 3
SQL_DATA_TYPE = null
SQL_DATETIME_SUB = null
UNSIGNED_ATTRIBUTE = null
TYPE_NAME = DATETIME
AUTO_INCREMENT = false
CASE_SENSITIVE = false
CREATE_PARAMS = null
DATA_TYPE = 93
FIXED_PREC_SCALE = false
LITERAL_PREFIX = '
LITERAL_SUFFIX = '
LOCAL_TYPE_NAME = DATETIME
MAXIMUM_SCALE = 0
 
MINIMUM_SCALE = 0
NULLABLE = 1
NUM_PREC_RADIX = null
PRECISION = 19
SEARCHABLE = 3
SQL_DATA_TYPE = null
SQL_DATETIME_SUB = null
UNSIGNED_ATTRIBUTE = null
TYPE_NAME = DECIMAL
AUTO_INCREMENT = false
CASE_SENSITIVE = false
CREATE_PARAMS = null
DATA_TYPE = 8
FIXED_PREC_SCALE = false
LITERAL_PREFIX = null
LITERAL_SUFFIX = null
LOCAL_TYPE_NAME = DECIMAL
MAXIMUM_SCALE = 18
 
MINIMUM_SCALE = 0
NULLABLE = 1
NUM_PREC_RADIX = 10
PRECISION = 18
SEARCHABLE = 3
SQL_DATA_TYPE = null
SQL_DATETIME_SUB = null
UNSIGNED_ATTRIBUTE =false
TYPE_NAME = ID
AUTO_INCREMENT = true
CASE_SENSITIVE = false
CREATE_PARAMS = null
DATA_TYPE = -5
FIXED_PREC_SCALE = false
LITERAL_PREFIX = null
LITERAL_SUFFIX = null
LOCAL_TYPE_NAME = ID
MAXIMUM_SCALE = 0
 
MINIMUM_SCALE = 0
NULLABLE = 1
NUM_PREC_RADIX = 10
PRECISION = 19
SEARCHABLE = 3
SQL_DATA_TYPE = null
SQL_DATETIME_SUB = null
UNSIGNED_ATTRIBUTE = false
TYPE_NAME =INTEGER
AUTO_INCREMENT = false
CASE_SENSITIVE = false
CREATE_PARAMS = null
DATA_TYPE = 4
FIXED_PREC_SCALE = false
LITERAL_PREFIX = null
LITERAL_SUFFIX = null
LOCAL_TYPE_NAME = INTEGER
MAXIMUM_SCALE = 0
 
MINIMUM_SCALE = 0
NULLABLE = 1
NUM_PREC_RADIX = 10
PRECISION = 10
SEARCHABLE = 3
SQL_DATA_TYPE = null
SQL_DATETIME_SUB = null
UNSIGNED_ATTRIBUTE = false
TYPE_NAME = LONG
AUTO_INCREMENT = false
CASE_SENSITIVE = false
CREATE_PARAMS = null
DATA_TYPE = -5
FIXED_PREC_SCALE = false
LITERAL_PREFIX = null
LITERAL_SUFFIX = null
LOCAL_TYPE_NAME = LONG
MAXIMUM_SCALE = 0
 
MINIMUM_SCALE = 0
NULLABLE = 1
NUM_PREC_RADIX = 10
PRECISION = 19
SEARCHABLE = 3
SQL_DATA_TYPE = null
SQL_DATETIME_SUB = null
UNSIGNED_ATTRIBUTE = false
TYPE_NAME = LONGTEXT
AUTO_INCREMENT = false
CASE_SENSITIVE = false
CREATE_PARAMS = null
DATA_TYPE = -1
FIXED_PREC_SCALE = false
LITERAL_PREFIX = '
LITERAL_SUFFIX = '
LOCAL_TYPE_NAME = LONGTEXT
MAXIMUM_SCALE = null
 
MINIMUM_SCALE = null
NULLABLE = 1
NUM_PREC_RADIX = null
PRECISION = 1048576
SEARCHABLE = 0
SQL_DATA_TYPE = null
SQL_DATETIME_SUB = null
UNSIGNED_ATTRIBUTE = null
TYPE_NAME = STRING
AUTO_INCREMENT = false
CASE_SENSITIVE = false
CREATE_PARAMS = null
DATA_TYPE = 12
FIXED_PREC_SCALE = false
LITERAL_PREFIX = '
LITERAL_SUFFIX = '
LOCAL_TYPE_NAME = STRING
MAXIMUM_SCALE = null
 
MINIMUM_SCALE = null
NULLABLE = 1
NUM_PREC_RADIX = null
PRECISION = 255
SEARCHABLE = 3
SQL_DATA_TYPE = null
SQL_DATETIME_SUB = null
UNSIGNED_ATTRIBUTE = null