Description Usage Arguments Details Value References See Also Examples
This method is a straight-forward implementation of the corresponding generic function.
1 2 |
res |
an |
n |
maximum number of records to retrieve per fetch.
Use |
... |
currently unused. |
The ROracle
implementations retrieves only n
records,
and if n
is missing it returns all records.
number of records fetched from database.
For the Oracle Database documentaion see http://www.oracle.com/technetwork/indexes/documentation/index.html.
Oracle
,
dbConnect
,
dbSendQuery
,
dbGetQuery
,
dbClearResult
,
dbCommit
,
dbGetInfo
,
dbReadTable
.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 | ## 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)
|
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.