Re: [R] Joining R Local Dataset with Table from Database

You'll either need to do it in R or Oracle (I'm not sure you can do it directly across the ODBC boundary) -- I'd actually think Oracle would be more performant for this sort of thing. But anyways, import your data from Oracle into R as a data.frame and then look at the ?merge command. Best, Micha

[R] Joining R Local Dataset with Table from Database

Hi All, I want to join a table (Dataset) that 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