OraResult-class: Class OraResult

Description Generators Extends Methods See Also Examples

Description

An Oracle query results class. This class encapsulates the result of a SQL statement.

Generators

The main generator is dbSendQuery.

Extends

Class "DBIResult", directly. Class "DBIObject", by class "DBIResult", distance 2.

Methods

dbClearResult

signature(res = "OraResult"): ...

dbColumnInfo

signature(res = "OraResult"): ...

dbGetInfo

signature(dbObj = "OraResult"): ...

dbGetStatement

signature(res = "OraResult"): ...

dbGetRowCount

signature(res = "OraResult"): ...

dbGetRowsAffected

signature(res = "OraResult"): ...

dbHasCompleted

signature(res = "OraResult"): ...

fetch

signature(res = "OraResult", n = "numeric"): ...

fetch

signature(res = "OraResult", n = "missing"): ...

execute

signature(res = "OraResult"): ...

summary

signature(object = "OraResult"): ...

show

signature(object = "OraResult")

See Also

DBI classes: OraDriver-class OraConnection-class OraResult-class

Examples

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
## Not run: 
ora <- dbDriver("Oracle")
con <- dbConnect(ora, "scott", "tiger")
res <- dbSendQuery(con, "select * from emp")
fetch(res, n = 2)
fetch(res)
dbColumnInfo(res)
dbClearResult(res)

## End(Not run)

ROracle documentation built on May 30, 2017, 4:47 a.m.