Skip to content

Instantly share code, notes, and snippets.

@espinielli

espinielli/R: connect to DB (Oracle) table

Last active April 2, 2019 13:36
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save espinielli/34eda39db53b68371e0fde8cb1739514 to your computer and use it in GitHub Desktop.
Save espinielli/34eda39db53b68371e0fde8cb1739514 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
R: connect to DB (Oracle) table
library(dplyr)
library(dplyr)
library(ROracle)
drv <- dbDriver("Oracle")
con <- dbConnect(
drv,
Sys.getenv("PRU_TEST_USR"),
Sys.getenv("PRU_TEST_PWD"),
dbname = Sys.getenv("PRU_TEST_DBNAME"))
top_apts <- tbl(con, "SP_TOP_APTS") %>%
filter(YEAR == 2018) %>%
arrange(-NBR_MVMTS)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment