Learn R Programming
⚠️There's a newer version (1.3-1.1) of this package.Take me there.

ROracle (version 0.3-3)

Oracle database interface for R

Description

Oracle database interface driver for R. This driver uses the ProC/C++ embedded SQL. Note that this is a transitional version, and the next version is meant to be entirely based on the DBI (see the package DBI 0.1-3 and the library(methods).

Copy Link

Version

Install

install.packages('ROracle')

Monthly Downloads

4,438

Version

0.3-3

License

LGPL version 2 or newer

Maintainer

David James

Last Published

November 10th, 2021

Functions in ROracle (0.3-3)

getManager

Get a database manager object from a derived handle
Oracle

Instantiate an Oracle client from the current R or S session
dbManager

Instantiate a database manager
dbConnect

Create a connection to a RDBMS
SQLDataType

Determine the SQL Data Type of an R/S object
S4R

R compatibility with S version 4/Splus5+ support functions
dbExecStatement

Execute an SQL statement on a given database connection
metaData

R/S database interface meta-data
getTable

Convenience functions for Importing/Exporting DBMS tables into R/S. (Note: not all yet implmented by the Oracle driver.)
methods.Oracle

Support Ora methods
describe

Describe an object through its meta-data
make.SQL.names

Make R/S identifiers into legal SQL identifiers.
isSQLKeyword

Is a name an SQL keyword?
setDataMappings

Set data mappings between an RDBMS and R/S
dbExec

Execute an SQL statement on a given database connection
callProc

Call an SQL stored procedure
parse.OraConParams

Parse an Oracle connection string
safe.write

Write a data.frame avoiding exceeding memory limits
quickSQL

Quick SQL Execution
fetch

Fetch records from a previously executed SELECT statement
isIdCurrent

Check whether a database handle object is valid or not
commit

RDBMS Transaction Management
getNumRows

Get number of rows/columns of an SQL table
load

Load/unload the client part of a database interface
supportObjects

Support objects for RS-DBI