复制代码 代码如下:

select line,text from dba_source where;
select object_name,object_type from dba_objects where object_type='PROCEDURE';