ROracle (version 1.3-1)

OraResult-class: Class OraResult

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

# 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)
# }

Run the code above in your browser using DataCamp Workspace