Skip to content

[OGRUG] Examples using Oracle

4 messages · Helder Mendes, Paul Gilbert, Amin Adatia

Paul Gilbert
# 
There are really two separate questions here: how to import data from 
Oracle? and how to make a graph in R?

For the second, there are lots of examples ( eg 
http://rgraphgallery.blogspot.ca/ ).

The first is more difficult to find examples because one needs access to 
an Oracle database. If you have that and some standard SQL queries that 
extract the data you want then we can probably work out some examples. I 
don't currently have Oracle, but standard SQL queries are not very 
different from one engine to another. (It is the enhancements that are 
different.)

It is the installation of the R packages that is likely to be most 
difficult. The two options are packages ROracle and RODBC.  I would 
generally prefer ROracle unless your database administrators are 
enforcing use of ODBC only. Certainly I would not recommend RODBC unless 
it is supported on the database end.

Paul
On 04/27/2014 05:39 PM, Amin Adatia wrote: