Purpose
The DBA_VIEWS view displays all views in the database.
References
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 length of the view text. |
| TEXT | VARCHAR2(4000) | NO | The view text. |
| OID_TEXT_LENGTH | NUMBER | NO | At present, this column is not supported and its value is NULL by default. |
| OID_TEXT | VARCHAR2(4000) | NO | At present, this column is not supported and its value is NULL by default. |
| VIEW_TYPE | VARCHAR2(30) | NO | At present, this column is not supported and its value is NULL by default. |
| SUPERVIEW_NAME | VARCHAR2(30) | NO | At present, this column is not supported and its value is NULL by default. |
| EDITIONING_VIEW | VARCHAR2(1) | NO | At present, this column is not supported and its value is NULL by default. |
| READ_ONLY | VARCHAR2(1) | NO | At present, this column is not supported and its value is NULL by default. |