OraRun: Runs a SQL query in preferred environment.

In neemtreeparrot/deebee: Database connectivity made simple

Description

Runs a SQL query in Oracle and returns a resultset.

Usage

OraRun(query, env = "dev")

Arguments

query	SQL Query to execute.
env	Environment name as string. The function will parse the environment name to its equivalent connection string stored under ora_connstr_[env]. This connection must be defined in advance that must contain five variables host_name, port, sid, user_name, pwd. Defaults to environment dev. E.g., ora_connstr_dev <- list(host_name = "localhost", port = "1521", sid = "xe", user_name = "sc", pwd = "tiger")

Value

SQL resultset as a tibble

Examples

ora_connstr_dev <- list(host_name = "localhost", port = "1521", sid = "xe", user_name = "sc", pwd = "tiger")
OraRun("SELECT * FROM ALL_TABLES", "dev")

neemtreeparrot/deebee documentation built on May 6, 2019, 12:05 a.m.