The DBA_VIEWS view provides the information about all views in the database.
Parameter | Type | Description |
---|---|---|
owner | TEXT | The username of the owner to which a 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 tex of the SELECT statement that defines the view. |