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

ROracle (version 0.5-4)

Oracle database interface for R

Description

Oracle database interface (DBI) driver for R. This is a DBI-compliant Oracle driver based on the ProC/C++ embedded SQL. It implements the DBI version 0.1-4 plus one extension.

Copy Link

Version

Install

install.packages('ROracle')

Monthly Downloads

1,695

Version

0.5-4

License

LGPL version 2 or newer

Maintainer

David James

Last Published

October 27th, 2025

Functions in ROracle (0.5-4)

OraResult-class

Class OraResult
dbSendQuery-methods

Execute a statement on a given database connection
dbPrepareStatement-methods

Create a prepared SQL statement for repeated execution
dbSetDataMappings-methods

Set data mappings between Oracle and R/S-Plus
Oracle

Instantiate an Oracle client from the current R/S-Plus session
OraPreparedStatement-class

Oracle Prepared Statement
dbConnect-methods

Create a connection object to an Oracle DBMS
dbReadTable-methods

Convenience functions for Importing/Exporting DBMS tables
safe.write

Write a data.frame avoiding exceeding memory limits
OraObject-class

Class OraObject
dbListTables-methods

List items from an Oracle DBMS and from objects
dbObjectId-class

Class dbObjectId
DBIPreparedStatement-class

Class DBIPreparedStatement
dbDataType-methods

Determine the SQL Data Type of an S object
fetch-methods

Fetch records from a previously executed query
oraParseConParams

Parse an Oracle connection string
OraDriver-class

Class OraDriver
OraConnection-class

Class OraConnection
dbGetInfo-methods

Database interface meta-data
dbCallProc-methods

Call an SQL stored procedure
dbPrepareStatement

Create a prepared SQL statement for repeated execution
isIdCurrent

Check whether an dbObjectId handle object is valid or not
S4R

R compatibility with S version 4/S-Plus 5+ support functions
dbCommit-methods

DBMS Transaction Management
oraSupport

Support Functions
summary-methods

Summarize an Oracle object
make.db.names-methods

Make R/S-Plus identifiers into legal SQL identifiers
dbDriver-methods

Oracle implementation of the Database Interface (DBI) classes and drivers