considerate_qry: Considerately run a SQL query, closing the database...

In moj-analytical-services/oracleConnectR: Wrapper Package for Simple Connection to Oracle Databases

Description

Considerately run a SQL query, closing the database connection on completion.

Usage

considerate_qry(
  db_name,
  qry = NULL,
  qry_path = NULL,
  config_path = NULL,
  driver = NULL,
  ...
)

Arguments

db_name	A list containing database credentials
qry	A character string containing a SQL query
qry_path	A character string containing a path to a .sql file
config_path	Optional character string with the location to the config file with database connection details
driver	Optional character string specifying the database driver to use (currently supports 'odbc' (default) or 'ROracle'.
...	Optional arguments to be passed to write.csv

Value

A data frame containing records fetched by a SQL query

moj-analytical-services/oracleConnectR documentation built on March 13, 2021, 5:55 p.m.