ALL_VIEWS

The ALL_VIEWS view provides information about all views accessible to the current user.

Column name Data type Description
OWNER VARCHAR2(30) The owner of the view.
Always INLINE.
VIEW_NAME VARCHAR2(30) The name of the view.
Always INLINE.
TEXT_LENGTH NUMBER The length of the view text.
TEXT VARCHAR2(409600) The text of the view.
Always NOT INLINE.