Hello Madan,
I am rather novice as well, so I went the ODBC way.
If you define an ODBC connection to Oracle, with System DSN dsn-name,
the code to get the results of a query into, say, mydata is like :
library(RODBC) # First of all
channel <- odbcConnect("dsn-name", uid="someuser") # double quotes
required, it will ask for the password
# Return rows from an SQL query
mydata <- sqlQuery (channel, "Select .... put your query here ...") #
same as before
odbcClose(channel) # When you're done
HTH,
Gabriele Franzini
ICT Applications Manager
Nerviano Medical Sciences SRL
Nerviano Italy
______________________________________________
R-help@r-project.org mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.
