You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
14 lines
618 B
14 lines
618 B
library(rJava)
|
|
library(RJDBC)
|
|
con <- dbConnect(JDBC(driverClass = "oracle.jdbc.OracleDriver",
|
|
classPath = "/home/ducj/설정파일/ojdbc11-full/ojdbc11.jar"),
|
|
"jdbc:oracle:thin:@ducj3.iptime.org:1521/xe",
|
|
"ducj", Sys.getenv('db_key'))
|
|
|
|
tables=RJDBC::dbListTables(con)
|
|
setdiff(tables,grep('^(AWR|ALL|CDB|DBA|GV|HTTPClient|KU|OWA|PDB|DBMS|SI|SQL|ST|SYS|SDO|USER)',tables,value=T))
|
|
RJDBC::dbReadTable(con,'PLAYER')
|
|
#https://www.oracle.com/database/technologies/appdev/jdbc-downloads.html
|
|
|
|
query <- "SQL query 입력"
|
|
data <- dbGetQuery(DB, query) %>% setDT()
|
|
|