Advertisement
Guest User

Untitled

a guest
Sep 6th, 2016
72
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.52 KB | None | 0 0
  1. install.packages("rJava")
  2. library(DBI)
  3. library(RJDBC)
  4. library(rJava)
  5.  
  6.  
  7. require(RJDBC);
  8. require(rJava);
  9.  
  10. drv <- JDBC(driverClass = "oracle.jdbc.driver.OracleDriver",
  11. classPath = "D:/app/choi/product/11.2.0/dbhome_1/jdbc/lib/ojdbc6.jar",
  12. "`");
  13.  
  14. conn <- dbConnect(drv,
  15. "jdbc:oracle:thin:@localhost:1521:ORCL",
  16. "ZP_DW",
  17. "ZP_DW");
  18.  
  19. rst <- dbGetQuery(conn, "select * from T_RIVAL_PARTY_EXP1");
  20.  
  21. str(rst)
  22. head(rst)
  23. View(rst)
  24.  
  25. View(summary(rst))
  26.  
  27.  
  28. sapply(split)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement