R语言ORACLE数据库连接

library(RJDBC)

drv <-JDBC("oracle.jdbc.driver.OracleDriver","ojdbc6_g",identifier.quote="`")

 注：ojdbc6_g是oracle的驱动包，需要提前下载放到R当前目录下

conn <-dbConnect(drv,"jdbc:oracle:thin:@192.168.0.11:1521/test","abcd","123456")

删除表：

dbRemoveTable(conn,"test1")

创建表、插入数据、更新数据

dbSendUpdate(conn,"create table test1( id number )");

dbSendUpdate(conn,"insert into test1values(1)");

dbSendUpdate(conn,"update test1 setid=2 where id=1");

dbSendUpdate(conn,"delete from test1where id=2");

 

查询数据

train <- dbGetQuery(conn,"select *from test1");