[OGRUG] Examples using Oracle
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:
Hi! Does anyone have examples of using R to plot graphs from data tables in Oracle database? Regards Amin Adatia (amin at knowtech.ca) KnowTech Solutions Inc. (www.knowtech.ca) Mobile : +1-613-864-8378 [[alternative HTML version deleted]]
_______________________________________________ R-UG-Ottawa mailing list R-UG-Ottawa at r-project.org https://stat.ethz.ch/mailman/listinfo/r-ug-ottawa