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.


News


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 as.POSIXct.data.frame() 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.

install.packages("ora")

2.0-1 by Arni Magnusson, 6 years ago


Browse source code at https://github.com/cran/ora


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