oracle查询存储过程内容(包体内也可查询)

清华大佬耗费三个月吐血整理的几百G的资源,免费分享!....>>>

 SELECT TEXT FROM ALL_SOURCE
WHERE TYPE = 'PACKAGE BODY' AND
OWNER = 'HECC'
ORDER BY NAME, LINE;