odbc (version 1.4.1)

Oracle-class: Oracle

Description

Details of Oracle methods for odbc and DBI generics.

odbcConnectionTables()

Query, rather than use SQLTables ODBC API for performance reasons. Main functional difference between the implementation of SQLTables in the OEM driver and the query below is that the OEM implementation also looks through the synonyms. Given the performance reports, we sacrifice the synonym look-through for better execution time.

odbcConnectionColumns()

Query, rather than use SQLColumns ODBC API, since we bind a BIGINT to one of the column results and Oracle's OEM driver can't handle it.

Usage

# S4 method for Oracle
sqlCreateTable(
  con,
  table,
  fields,
  row.names = NA,
  temporary = FALSE,
  ...,
  field.types = NULL
)
# S4 method for Oracle,character
odbcConnectionTables(
  conn,
  name,
  catalog_name = NULL,
  schema_name = NULL,
  table_type = NULL,
  exact = FALSE
)
# S4 method for Oracle,character
odbcConnectionColumns(
  conn,
  name,
  catalog_name = NULL,
  schema_name = NULL,
  column_name = NULL,
  exact = FALSE
)