Oracle查询所有表名及注释、字段名及注释

select t.owner||'.'||t.table_name,c.comments from all_tables t
left join all_tab_comments c on t.owner=c.owner and t.table_name =c.table_name  
where  t.owner = 'XXX'
order by t.table_name;

 查字段：

select *
from all_tab_columns 
where column_name like 'UPLOAD_FLAG'
order by column_name;

 查字段注释：

select * from all_col_comments where column_name ='NODE_PICK';

查存储过程

SELECT *
FROM all_source
WHERE  UPPER(TEXT)  LIKE '%MYGROUP%'