[R/COMMON] Oracle 데이터베이스 사용하기

icodebroker COMMON 2024-06-20

■ Oracle 데이터베이스를 사용하는 방법을 보여준다.

▶ 예제 코드 (PY)


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)

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

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)

ojdbc6-11.2.0.3.zip