查询数据:
library(DBI)
library(rJava)
library(RJDBC)
library(RODBC)
drv <- JDBC(driverClass="oracle.jdbc.driver.OracleDriver", classPath = "路径/ojdbc6.jar")
conn <- dbConnect(drv , "jdbc:oracle:thin:@ip:端口/实例名" , "用户名" , "密码")
hr2 <- dbGetQuery(conn , sql)
写入数据:
dbWriteTable(conn , "tableName" , data)