Learn R Programming

ROracle (version 1.2-1)

dbGetInfo-methods: Database interface Metadata

Description

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

Usage

## S3 method for class 'OraDriver':
dbGetInfo(dbObj, ...)
## S3 method for class 'ExtDriver':
dbGetInfo(dbObj, ...)
## S3 method for class 'OraConnection':
dbGetInfo(dbObj, what, ...)
## S3 method for class 'OraResult':
dbGetInfo(dbObj, what, ...)
## S3 method for class 'OraResult':
dbGetStatement(res, ...)
## S3 method for class 'OraResult':
dbGetRowCount(res, ...)
## S3 method for class 'OraResult':
dbGetRowsAffected(res, ...)
## S3 method for class 'OraResult':
dbColumnInfo(res, ...)
## S3 method for class 'OraResult':
dbHasCompleted(res)

Arguments

dbObj
Any object that implements some functionality in the R interface to databases (a driver, a connection, or a result set).
what
A character string specifying an element of the output list.
res
An OraResult.
...
Currently unused.

Value

  • Information about driver, connection or a result set object.

pkg

  • ROracle
  • ROracle
  • ROracle

code

dbColumnInfo

itemize

  • \$name

item

  • $dbname
  • $serverVersion
  • $serverType
  • $resTotal
  • $resOpen
  • $prefetch
  • $bulk_read
  • $bulk_write
  • $stmt_cache
  • $results
  • $isSelect
  • $rowsAffected
  • $rowCount
  • $completed
  • $prefetch
  • $bulk_read
  • $bulk_write
  • $fields
  • $Sclass
  • $type
  • $len
  • $precision
  • $scale
  • $nullOK

preformatted

library(ROracle) Loading required package: DBI > # instantiate ROracle driver object > drv <- Oracle() > con <- dbConnect(drv, "scott", "tiger") > rs <- dbSendQuery(con, "select * from foo") > dbGetInfo(drv) $driverName [1] "Oracle (OCI)"

$driverVersion [1] "1.1-12"

$clientVersion [1] "11.2.0.4.0"

$conTotal [1] 1

$conOpen [1] 1

$interruptible [1] FALSE

$unicode_as_utf8 [1] TRUE

$ora_attributes [1] TRUE

$connections $connections[[1]] User name: scott Connect string: Server version: 11.2.0.4.0 Server type: Oracle RDBMS Results processed: 1 OCI prefetch: FALSE Bulk read: 1000 Bulk write: 1000 Statement cache size: 0 Open results: 1

> dbGetInfo(con) $username [1] "scott"

$dbname [1] ""

$serverVersion [1] "11.2.0.4.0"

$serverType [1] "Oracle RDBMS"

$resTotal [1] 1

$resOpen [1] 1

$prefetch [1] FALSE

$bulk_read [1] 1000

$bulk_write [1] 1000

$stmt_cache [1] 0

$results $results[[1]] Statement: select * from foo Rows affected: 0 Row count: 0 Select statement: TRUE Statement completed: FALSE OCI prefetch: FALSE Bulk read: 1000 Bulk write: 1000

> dbGetInfo(rs) $statement [1] "select * from foo"

$isSelect [1] TRUE

$rowsAffected [1] 0

$rowCount [1] 0

$completed [1] FALSE

$prefetch [1] FALSE

$bulk_read [1] 1000

$bulk_write [1] 1000

$fields name Sclass type len precision scale nullOK 1 A numeric NUMBER NA 21 0 TRUE 2 B numeric NUMBER NA 0 -127 TRUE 3 C character CHAR 20 0 0 TRUE 4 D character VARCHAR2 300 0 0 TRUE 5 E numeric BINARY_DOUBLE NA 0 0 TRUE 6 F numeric BINARY_FLOAT NA 0 0 TRUE 7 G character CLOB NA 0 0 TRUE 8 H raw BLOB NA 0 0 TRUE 9 I raw BFILE NA 0 0 TRUE 10 J POSIXct DATE NA 0 0 TRUE 11 M POSIXct TIMESTAMP NA 0 6 TRUE 12 N POSIXct TIMESTAMP WITH TIME ZONE NA 0 6 TRUE 13 O POSIXct TIMESTAMP WITH LOCAL TIME ZONE NA 0 6 TRUE 14 R difftime INTERVAL DAY TO SECOND NA 2 6 TRUE 15 S raw RAW 234 0 0 TRUE

References

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

Details

Table, schema, and column names are case sensitive, for example, table names ABC and abc are not the same. All database schema object names should not include double quotes as they are enclosed in double quotes when the corresponding SQL statement is generated.

The ROracle method dbGetInfo provides following details about the driver object:

  • \$driverName
The name of the driver, "Oracle (OCI)" $driverVersion The version of the ROracle driver used $clientVersion The version of the Oracle Client library used $conTotal The number of connections instantiated by the driver $conOpen The number of connections open currently $interruptible TRUE when a long-running query can be interrupted $unicode_as_utf8 TRUE when character data is to be fetched in UTF8 encoded format $ora_attributes TRUE when each column in a result set data frame has corresponding Oracle DBMS attributes $connections Information about each connection currently open, see dbGetInfo of connection object for details

See Also

Oracle, dbDriver, dbConnect, dbSendQuery, dbGetQuery, fetch, dbCommit, dbGetInfo, dbListTables, dbReadTable.

Examples

Run this code
drv <- dbDriver("Oracle")
    con <- dbConnect(drv, "scott", "tiger")

    rs <- dbSendQuery(con, "select * from emp")

    # Get the SQL statement for the result set object rs
    dbGetStatement(rs)

    # Are there any more rows in result set?
    dbHasCompleted(rs)

    # Information about columns in result set rs object
    dbColumnInfo(rs)

    # DBIDriver info
    names(dbGetInfo(drv))

    # DBIConnection info
    names(dbGetInfo(con))

    # DBIResult info
    names(dbGetInfo(rs))

Run the code above in your browser using DataLab