The ALL_VIEWS view provides the information about all user-defined views.
Parameter | Type | Description |
---|---|---|
owner | TEXT | The username of the owner to which the view belongs. |
schema_name | TEXT | The name of the schema to which the view belongs. |
view_name | TEXT | The name of the view. |
text | TEXT | The SELECT statement that defines the view. |