USER_VIEWS v16

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

NameTypeDescription
schema_nameTEXTName of the schema in which the view resides.
view_nameTEXTName of the view.
textTEXTThe SELECT statement that defines the view.