oracle 数据字典视图之 DICT / DICTIONARY

1.当你猛然间忘记通过什么视图可以查看procedure内容时，隐约记得所需的视图包含“SOUR”字段，此时查询dict/dictionary视图是最好的选择
sys@ora10g> col COMMENTS for a78
sys@ora10g>select * from dict where TABLE_NAME like '%SOUR%';
TABLE_NAME                     COMMENTS
------------------------------ -----------------------------------------------------------
USER_RESOURCE_LIMITS           Display resource limit of the user
ALL_SOURCE_TABLES              Source tables available for Change Data Capture
DBA_SOURCE_TABLES              Source tables available for Change Data Capture
USER_SOURCE_TABLES             Source tables available for Change Data Capture
USER_SOURCE                    Source of stored objects accessible to the user
ALL_SOURCE                     Current source on stored objects that user is allowed to create
DBA_SOURCE                     Source of all stored objects in the database
DBA_TSM_SOURCE                 Transparent session migration source session statistics
DBA_HIST_RESOURCE_LIMIT        Resource Limit Historical Statistics Information
DBA_RESOURCE_INCARNATIONS      Resource incarnations that are running or eligible for HA status notification
RESOURCE_C