allviews
Syntax
allviews [[owner_name_pattern.] view_name_pattern]
Description
Lists, in a single column, the names of all the views that match the
specified pattern selected from SYS.ALL_OBJECTS
. When a pattern is
missing, the pattern defaults to "%
".
If passthrough is enabled, lists views matching the pattern in the Oracle database.
For more details, see List Database Objects by Object Type.
Examples
Command> allviews; SYS.ALL_ARGUMENTS SYS.ALL_COL_PRIVS SYS.ALL_DEPENDENCIES