经常因为忘记数据字典表名而烦恼
死记硬背太麻烦
只要记得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>
转载于:https://www.cnblogs.com/cycsa/archive/2013/05/14/3077468.html
