OraRun_: Runs a SQL query in Oracle

In neemtreeparrot/deebee: Database connectivity made simple

Description

Runs a SQL query in Oracle and returns a resultset.

Usage

OraRun_(query, host_name, port = "1521", sid = "xe", user_name, pwd)

Arguments

query	SQL Query to execute.
host_name	Host name.
port	Port name. Defaults to port 1521.
sid	Service Id. Defaults to xe.
user_name	User name for the connection in plain text.
pwd	Password for the connection in plain text.

Value

SQL resultset in a tibble

Examples

OraRun_("SELECT * FROM ALL_TABLES", "localhost", 1521, xe, "sc", "tiger")

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