ora (version 2.0-1)

views: List Oracle Views

Description

List all views in the database belonging to a specific owner.

Usage

views(owner="%", view="%", tolower=TRUE, ...)

Arguments

owner

owner name.

view

view name.

tolower

whether owner and view output entries should be lowercased.

...

passed to dbConnect.

Value

owner

owner name.

view

view name.

Details

The arguments owner and view, are passed as patterns that are matched by LIKE, where % means any number of characters and _ means exactly one character. Literal % and _ are escaped using two backslashes: "\\%" and "\\_".

In other words, the default value "%" matches all strings.

The ... argument can be used to set username, password, and/or dbname (see dbConnect). Abbrevations like user and pass are allowed. The default database name is determined by the environment variable ORACLE_SID, which can be redefined within an R session using Sys.setenv(ORACLE_SID="foo").

See Also

views is to Oracle as ll (in package gdata) is to R environments.

ora gives an overview of the package.

Examples

## Not run: 
# 
# # Views belonging to owner "sys":
# views("sys")
# 
# # Views whose name contains "all", followed by at least one character:
# views(,"%all_%")
# 
# # Views whose name begins with "all_":
# views(,"all\\_%")
# 
# ## End(Not run)