Views, Synonyms, and Sequences Data Dictionary Views

The following views display information about views, synonyms, and sequences:

View Description
DBA_VIEWS

ALL_VIEWS

USER_VIEWS

 DBA view describes all views in the database. ALL view is restricted to views accessible to the current user. USER view is restricted to views owned by the current user.
DBA_SYNONYMS

ALL_SYNONYMS

USER_SYNONYMS

 These views describe synonyms.
DBA_SEQUENCES

ALL_SEQUENCES

USER_SEQUENCES

 These views describe sequences.
DBA_UPDATABLE_COLUMNS

ALL_UPDATABLE_COLUMNS

USER_UPDATABLE_COLUMNS

 These views describe all columns in join views that are updatable.

See Also:

Oracle Database Reference for complete descriptions of these views