I am working out the Query Part and will have enough of those soon enough. The Graphing I will check in/at the link you have given.

I am using ROracle to connect

Regards 
Amin Adatia 
KnowTech Solutions Inc ( http://knowtech.ca )
Mobile +1-613-864-8378
 
> Date: Mon, 28 Apr 2014 12:34:43 -0400
> From: pgilbert902@gmail.com
> To: amin@knowtech.ca
> CC: r-ug-ottawa@r-project.org
> Subject: Re: [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@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@r-project.org
> > https://stat.ethz.ch/mailman/listinfo/r-ug-ottawa
> >
 		 	   		  
	[[alternative HTML version deleted]]

