Convenient Tools for Working with Oracle Databases

Easy-to-use functions to explore Oracle databases and import data into R. User interface for the ROracle package.


ora 2.0-1 (2014-04-10)

o desc() shows LAST_ANALYZED date (shown below table) as a string, not integer.

ora 2.0-0 (2013-06-16)

o Renamed package from "ROracleUI" to "ora".

o Adapted to changes in ROracle 1.1-1 and later.

o Removed functions and to_char(), since ROracle now imports time/date columns as POSIX objects.

ROracleUI 1.3-2 (2011-04-11)

o Improved handling of ROracle error messages.

ROracleUI 1.3-1 (2011-02-18)

o Improved robustness to space-like characters [ \f\n\r\t\v\240].

ROracleUI 1.3-0 (2010-11-18)

o The '...' argument can be used to select user/pass/dbname in sql(), desc(), tables(), and views().

o Added argument 'encoding' to sql().

o desc() is robust to ambiguous table names.

ROracleUI 1.2-0 (2010-09-10)

o Added argument 'stringsAsFactors' to sql().

o Renamed argument 'warnings' to 'warn' in sql().

ROracleUI 1.1-3 (2010-08-27)

o Added Windows support.

ROracleUI 1.0-0 (2010-01-23)

o Initial release.

Reference manual

It appears you don't have a PDF plugin for this browser. You can click here to download the reference manual.


2.0-1 by Arni Magnusson, 7 years ago

Browse source code at

Authors: Arni Magnusson

Documentation:   PDF Manual  

Task views: Databases with R

GPL (>= 2) license

Depends on DBI, ROracle

System requirements: Oracle client

See at CRAN