■ Oracle 데이터베이스 사용하기

----------------------------------------------------------------------------------------------------


ojdbc6-11.2.0.3.jar


install.packages("rJava")

install.packages("DBI")

install.packages("RJDBC")

 

library(DBI)

library(rJava)

library(RJDBC)

 

driver<-JDBC("oracle.jdbc.driver.OracleDriver", "C:\\ojdbc6-11.2.0.3.jar")

 

connection<-dbConnect(driver, "jdbc:oracle:thin:@127.0.0.1:1521/DBNAME", "USERID", "PASSWORD")

 

query<-"SELECT * FROM APP.TEST"

 

dbGetQuery(connection, query)

----------------------------------------------------------------------------------------------------

Posted by 사용자 icodebroker