USER_VIEWS

The USER_VIEWS view provides information about the views owned by the current user.

Column name Data type Description
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.