fetch-methods: Fetch records from a previously executed query

In ROracle: OCI Based Oracle Database Interface for R

Description

This method is a straight-forward implementation of the corresponding generic function.

Usage

## S4 method for signature 'OraResult'
fetch(res, n = -1, ...)

Arguments

res	an OraResult object.
n	maximum number of records to retrieve per fetch. Use n = -1 to retrieve all pending records.
...	currently unused.

Details

The ROracle implementations retrieves only n records, and if n is missing it returns all records.

Value

number of records fetched from database.

References

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

See Also

Oracle, dbConnect, dbSendQuery, dbGetQuery, dbClearResult, dbCommit, dbGetInfo, dbReadTable.

Examples

  ## Not run: 
    drv <- dbDriver("Oracle")
    con <- dbConnect(drv, "scott", "tiger")
    res <- dbSendQuery(con, "select * from emp")

    # we now fetch the first 10 records from the resultSet into a data.frame
    data1 <- fetch(res, n = 10)   
    dim(data1)

    dbHasCompleted(res)

    # let's get all remaining records
    data2 <- fetch(res, n = -1)
  
## End(Not run)

ROracle documentation built on Nov. 10, 2021, 5:08 p.m.