get_oracle_tables: Extract ALL oracle tables in database

In andybeet/dbutils: Utility package for db connectivity and functionality

Extract ALL oracle tables in database

Description

Pulls a list of all of the tables and owners found within a database

Usage

get_oracle_tables(channel, owner = NULL)

Arguments

channel	DBI Object. Inherited from DBIConnection-class. This object is used to connect to communicate with the database engine. (see connect_to_database)
owner	character string. The name of the tables owner. Used to filter tables by a specific owner

Value

Data frame (n x 2)

column 1	Nam of the Database
column 2	Name of the table owner

The default sql statement ""SELECT table_name,owner FROM all_tables ORDER by owner"" is used

Reference

Use the data dictionary for an html list

See Also

connect_to_database

Examples

## Not run: 
# extracts ALL table names by owner from the database
channel <- connect_to_database(server="name_of_server",uid="individuals_username")
get_oracle_tables(channel)


#' # extracts ALL table names by owner = VTR from the database
channel <- connect_to_database(server="name_of_server",uid="individuals_username")
get_oracle_tables(channel,"VTR")

## End(Not run)

andybeet/dbutils documentation built on March 15, 2024, 4:43 p.m.