ROracle (version 1.5-1)

dbListConnections-methods: List items from Oracle objects

Description

These methods are straight-forward implementations of the corresponding generic functions.

Usage

# S4 method for OraDriver
dbListConnections(drv, ...)
# S4 method for ExtDriver
dbListConnections(drv, ...)
# S4 method for OraConnection
dbListResults(conn, ...)

Value

dbListConnections

A list of all connections associated with driver.

dbListResults

A list of all result sets associated with connection.

Arguments

drv

an OraDriver or ExtDriver.

conn

an OraConnection.

...

currently unused.

Details

dbListConnections

implementation return a list of all the associated connections. It shows information about all the associated connections.

dbListResults

implementation return a list of all associated result sets. It shows information about all associated result sets.

References

For the Oracle Database documentation see https://docs.oracle.com/en/.

See Also

Oracle, dbGetInfo, dbColumnInfo, dbDriver, dbConnect, dbSendQuery

Examples

  if (FALSE) {
    drv <- dbDriver("Oracle")
    con1 <- dbConnect(drv, "scott", "tiger")
    res1 <- dbSendQuery(con1, "select * from emp where deptno = 10")
    res2 <- dbSendQuery(con1, "select * from emp where deptno = 20")
    con2 <- dbConnect(drv, "scott", "tiger")
    res3 <- dbSendQuery(con2, "select * from dept")

    ## get all active statements
    for(con in dbListConnections(drv))
      for (res in dbListResults(con))
        print(dbGetStatement(res))
  }