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_sourcewhere type = 'package body' andowner = 'hecc'order by name, line;