Table: DBA_VIEWS
Description of all views in the database
| Column Name | Description |
|---|---|
| OID_TEXT | WITH OBJECT OID clause of the object view |
| OID_TEXT_LENGTH | Length of the WITH OBJECT OID clause of the object view |
| OWNER | Owner of the view |
| SUPERVIEW_NAME | Name of the superview, if view is a subview |
| TEXT | View text |
| TEXT_LENGTH | Length of the view text |
| TYPE_TEXT | Type clause of the object view |
| TYPE_TEXT_LENGTH | Length of the type clause of the object view |
| VIEW_NAME | Name of the view |
| VIEW_TYPE | Type of the view if the view is an object view |
| VIEW_TYPE_OWNER | Owner of the type of the view if the view is an object view |