ROracle (version 1.3-1.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, ...)

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.

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.

References

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

See Also

Oracle, dbGetInfo, dbColumnInfo, dbDriver, dbConnect, dbSendQuery

Examples

# NOT RUN {
  
# }
# 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))
  
# }

Run the code above in your browser using DataCamp Workspace