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 1. 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