Learn R Programming

ROracle (version 1.1-5)

dbDriver-methods: Oracle implementation of the Database Interface (DBI) classes and drivers

Description

Oracle driver initialization and closing

Arguments

drvName
character name of the driver to instantiate.
drv
an object that inherits from OraDriver as created by dbDriver.
...
any other arguments are passed to the driver drvName.

Value

  • dbDriverAn object OraDriver whose class extends DBIDriver. This object is used to create connections, using the function dbConnect, to one or several Oracle database engines.
  • dbUnloadDriverfree all resources occupied by driver object.

References

For the Oracle Database documentaion see http://www.oracle.com/technetwork/indexes/documentation/index.html.

Details

[object Object],[object Object]

See Also

Oracle, dbConnect, dbSendQuery, dbGetQuery, fetch, dbCommit, dbGetInfo, dbListTables, dbReadTable.

Examples

Run this code
# create an Oracle instance
    drv <- dbDriver("Oracle")

    con <- dbConnect(drv, "scott", "tiger")
    res <- dbSendQuery(con, "select * from emp")
    fetch(res, n = 5)
    fetch(res)
    dbClearResult(res)
    dbUnloadDriver(drv)

Run the code above in your browser using DataLab