如何查看oracle中存储过程的内容

select * from all_object a where a.object_type='procedure' and a.object_name like '%XXX%';

select * from all_object a where a.object_type='procedure' and a.object_name like '%XXX%';