dict数据字典表-忘记数据字典表也没关系

经常因为忘记数据字典表名而烦恼

死记硬背太麻烦

只要记得dict这个字典表即可：

 

SQL> desc dict;
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 TABLE_NAME                                         VARCHAR2(30)
 COMMENTS                                           VARCHAR2(4000)

SQL>  select table_name from dict where table_name like 'USER_IND%';

TABLE_NAME
------------------------------
USER_INDEXES
USER_INDEXTYPES
USER_INDEXTYPE_ARRAYTYPES
USER_INDEXTYPE_COMMENTS
USER_INDEXTYPE_OPERATORS
USER_IND_COLUMNS
USER_IND_EXPRESSIONS
USER_IND_PARTITIONS
USER_IND_STATISTICS
USER_IND_SUBPARTITIONS

10 rows selected.

SQL>