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

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

编程技巧