Learn R Programming

ROracle (version 1.1-11)

dbListConnections-methods: Oracle 对象的列表项

Description

这些方法是相应泛型函数的 简单实现。

Usage

## S3 method for class 'OraDriver':
dbListConnections(drv, ...)
## S3 method for class 'ExtDriver':
dbListConnections(drv, ...)
## S3 method for class 'OraConnection':
dbListResults(conn, ...)

Arguments

drv
一个 OraDriverExtDriver
conn
一个 OraConnection
...
当前未使用。

Value

  • dbListConnections与驱动程序关联的所有连接的列表。
  • dbListResults与连接关联的所有结果集的列表。

References

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

Details

\describe{ dbListConnections{ 实施返回所有关联连接的列表。 它显示有关所有关联连接的信息。 } dbListResults{ ���施返回所有关联结果集的列表。 它显示有关所有关联结果集的信息。 } }

See Also

Oracle, dbGetInfo, dbColumnInfo, dbDriver, dbConnect, dbSendQuery

Examples

Run this code
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 DataLab