首批通过分布式安全可靠测评，为关键业务系统打造
DICTIONARY
更新时间：2026-07-15 20:56:59
编辑
分享
说明
该视图从 V2.2.77 版本开始引入。
功能描述
展示当前租户下数据字典表和视图的描述。
功能适用性
该视图仅适用于 OceanBase 数据库 Oracle 模式。
字段说明
| 字段名称 | 类型 | 是否可以为 NULL | 描述 |
|---|---|---|---|
| TABLE_NAME | VARCHAR2(128) | NO | 对象的名称 |
| COMMENTS | VARCHAR2(4000) | NO | 对象的文本注释 |
查询示例
查看当前租户下数据字典表和视图的描述，展示前 10 条记录。
obclient[SYS]> SELECT * FROM SYS.DICTIONARY WHERE ROWNUM <=10;
查询结果如下：
+----------------+------------------------------------------------------------------+
| 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
