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