"dbGetInfo"(dbObj, ...)
"dbGetInfo"(dbObj, ...)
"dbGetInfo"(dbObj, what, ...)
"dbGetInfo"(dbObj, what, ...)
"dbGetStatement"(res, ...)
"dbGetRowCount"(res, ...)
"dbGetRowsAffected"(res, ...)
"dbColumnInfo"(res, ...)
"dbHasCompleted"(res)OraResult.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:
dbGetInfo of connection object for details
The ROracle method dbGetInfo provides following the details
about the connection object:
dbGetInfo of result set for details
The ROracle method dbGetInfo provides the following details
about the result set object:
dbColumnInfo for details
The ROracle method dbColumnInfo provides following details
about each column in the result set:
The example below shows the driver, connection, result set, and column information for a table containing:
create table foo(
a number(21),
b number,
c char(20),
d varchar(300),
e binary_double,
f binary_float,
g clob,
h blob,
i bfile,
j date,
m timestamp,
n timestamp with time zone,
o timestamp with local time zone,
r interval day to second,
s raw(234)
);
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
Oracle,
dbDriver,
dbConnect,
dbSendQuery,
dbGetQuery,
fetch,
dbCommit,
dbGetInfo,
dbListTables,
dbReadTable.
## Not run:
# 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))
# ## End(Not run)
Run the code above in your browser using DataLab