ROracle (version 1.1-5)

dbListConnections-methods: List items from Oracle objects

Description

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

Arguments

drv

an OraDriver.

conn

an OraConnection.

...

currently not used.

Value

• dbListConnections
  A list of all connections associated with driver.
• dbListResults
  A list of all result sets associated with connection.

References

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

Details

[object Object],[object Object]

See Also

Oracle, dbGetInfo, dbColumnInfo, dbDriver, dbConnect, dbSendQuery

Examples

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))