RDocumentation
Moon
Learn R
Search all packages and functions
⚠️
There's a newer version (1.3-1.1) of this package.
Take me there.
ROracle (version 0.3-1)
Oracle interface for R
Description
Oracle Database Interface driver for R This driver uses the ProC/C++ embedded SQL.
Copy Link
Copy
Link to current version
Version
Version
1.3-1.1
1.3-1
1.2-2
1.2-1
1.1-12
1.1-11
1.1-10
1.1-8
1.1-7
1.1-6
1.1-5
1.1-4
1.1-3
1.1-2
1.1-1
0.5-12
0.5-11
0.5-9
0.5-8
0.5-7
0.5-5
0.5-4
0.5-3
0.5-0
0.4-0
0.3-3
0.3-1
Down Chevron
Install
install.packages('ROracle')
Monthly Downloads
2,647
Version
0.3-1
License
LGPL version 2 or newer
Homepage
www.omegahat.org
Maintainer
David James
Last Published
November 9th, 2001
Functions in ROracle (0.3-1)
Search functions
fetch
Fetch records from a previously executed SELECT statement
dbConnect
Create a connection to a RDBMS
dbManager
Instantiate a database manager
getNumRows
Get number of rows/columns of an SQL table
metaData
R/S database interface meta-data
SQLDataType
Determine the SQL Data Type of an R/S object
dbExec
Execute an SQL script on a given database connection
methods.Oracle
Support Ora methods
make.SQL.names
Make R/S identifiers into legal SQL identifiers.
getTable
Convenience functions for Importing/Exporting DBMS tables into R/S. (Note: not all yet implmented by the Oracle driver.)
describe
Describe an object through its meta-data
callProc
Call an SQL stored procedure
quickSQL
Quick SQL Execution
isSQLKeyword
Is a name an SQL keyword?
isIdCurrent
Check whether a database handle object is valid or not
getManager
Get a database manager object from a derived handle
commit
RDBMS Transaction Management
Oracle
Instantiate an Oracle client from the current R or S session
S4R
R compatibility with S version 4/Splus5+ support functions
dbExecStatement
Execute an SQL statement on a given database connection
load
Load/unload the client part of a database interface
setDataMappings
Set data mappings between an RDBMS and R/S
supportObjects
Support objects for RS-DBI