Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- install.packages("rJava")
- library(DBI)
- library(RJDBC)
- library(rJava)
- require(RJDBC);
- require(rJava);
- drv <- JDBC(driverClass = "oracle.jdbc.driver.OracleDriver",
- classPath = "D:/app/choi/product/11.2.0/dbhome_1/jdbc/lib/ojdbc6.jar",
- "`");
- conn <- dbConnect(drv,
- "jdbc:oracle:thin:@localhost:1521:ORCL",
- "ZP_DW",
- "ZP_DW");
- rst <- dbGetQuery(conn, "select * from T_RIVAL_PARTY_EXP1");
- str(rst)
- head(rst)
- View(rst)
- View(summary(rst))
- sapply(split)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement