Oracle: Oracle

In odbc: Connect to ODBC Compatible Databases (using the DBI Interface)

Oracle

Description

Details of Oracle methods for odbc and DBI generics.

odbcConnectionTables()

Method for an internal function that otherwise relies on the SQLTables ODBC API. While this method is much faster than the OEM implementation, it does not look through synonyms.

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 signature 'Oracle'
sqlCreateTable(
  con,
  table,
  fields,
  row.names = NA,
  temporary = FALSE,
  ...,
  field.types = NULL
)

## S4 method for signature 'Oracle,character'
odbcConnectionTables(
  conn,
  name,
  catalog_name = NULL,
  schema_name = NULL,
  table_type = NULL,
  exact = FALSE
)

odbc documentation built on June 22, 2024, 9:47 a.m.