ROracle (version 1.2-2)

dbListConnections-methods: List items from Oracle objects

Description

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

Usage

"dbListConnections"(drv, ...)
"dbListConnections"(drv, ...)
"dbListResults"(conn, ...)

Arguments

drv

an OraDriver or ExtDriver.

conn

an OraConnection.

...

currently unused.

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

dbListConnections

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

dbListResults

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

See Also

Oracle, dbGetInfo, dbColumnInfo, dbDriver, dbConnect, dbSendQuery

Examples

  ## Not run: 
#     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))
#   ## End(Not run)