Displaying 1 result from an estimated 1 matches for "data_set_r".
Did you mean:
data_set
2012 Aug 02
1
Joining R Local Dataset with Table from Database
...is created in R with a table that is
in oracle database. Can some one help me in accomplishing this task in R?
Example Code:
library(RODBC)
DB_CONNECT <- odbcConnect("DSN_NAME")
TABLE_JOIN <- sqlQuery(DB_CONNECT, "SELECT * FROM DB_TABLE WHERE COL_1 NOT
IN (SELECT COL_1 FROM DATA_SET_R) ")
Regards,
Madana
--
View this message in context: http://r.789695.n4.nabble.com/Joining-R-Local-Dataset-with-Table-from-Database-tp4638967.html
Sent from the R help mailing list archive at Nabble.com.