Note
This view is available starting with V2.2.77.
Purpose
This view displays the descriptions of data dictionary tables and views in the current tenant.
Applicability
This view is available only in OceanBase Database in Oracle mode.
Columns
| Column | Type | Nullable | Description |
|---|---|---|---|
| TABLE_NAME | VARCHAR2(128) | NO | The name of the object. |
| COMMENTS | VARCHAR2(4000) | NO | The text comments of the object. |
Sample query
Query the descriptions of data dictionary tables and views in the current tenant and display the first 10 records.
obclient[SYS]> SELECT * FROM SYS.DICTIONARY WHERE ROWNUM <=10;
The query result is as follows:
+----------------+------------------------------------------------------------------+
| TABLE_NAME | COMMENTS |
+----------------+------------------------------------------------------------------+
| DBA_SYNONYMS | All synonyms in the database |
| DBA_OBJECTS | All objects in the database |
| ALL_OBJECTS | Objects accessible to the user |
| USER_OBJECTS | Objects owned by the user |
| DBA_SEQUENCES | Description of all SEQUENCEs in the database |
| ALL_SEQUENCES | Description of SEQUENCEs accessible to the user |
| USER_SEQUENCES | Description of the user's own SEQUENCEs |
| DBA_USERS | Information about all users of the database |
| ALL_USERS | Information about all users of the database |
| ALL_SYNONYMS | All synonyms for base objects accessible to the user and session |
+----------------+------------------------------------------------------------------+
10 rows in set