oracle查询存储过程内容（包体内也可查询）

SELECTTEXTFROMALL_SOURCE WHERETYPE=PACKAGEBODYAND OWNER=HECC ORDERBYNAME,LINE; Oracle SELECT TEXT FROM ALL_SOURCEWHERE TYPE = 'PACKAGE BODY' ANDOWNER = 'HECC'ORDER BY NAME, LINE;

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

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