Extract ALL oracle tables in database — get_oracle_tables • dbutils

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

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

if (FALSE) {
# 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")
}