Purpose
The DBA_VIEWS view displays all views in the database.
Related views
ALL_VIEWS
USER_VIEWS
Columns
| Column | Type | Nullable? | Description |
|---|---|---|---|
| OWNER | VARCHAR2(128) | NO | The owner of the view. |
| VIEW_NAME | VARCHAR2(128) | NO | The name of the index. |
| TEXT_LENGTH | NUMBER | NO | The defined length of the view. |
| TEXT | VARCHAR2(4000) | NO | The view text. |
| OID_TEXT_LENGTH | NUMBER | NO | The length of the WITH OID clause of the typed view. |
| OID_TEXT | VARCHAR2(4000) | NO | The WITH OID clause of the typed view. |
| VIEW_TYPE | VARCHAR2(30) | NO | The type of the view if the view is a typed view. |
| SUPERVIEW_NAME | VARCHAR2(30) | NO | The name of the superview. |
| EDITIONING_VIEW | VARCHAR2(1) | NO | Reserved for future use. |
| READ_ONLY | VARCHAR2(1) | NO | Indicates whether the view is read-only. |