select owner,type,name from sys.ALL_DEPENDENCIES where referenced_owner=? and referenced_name=? and referenced_type='PROCEDURE' order by owner,type,name
create function get_filed(p_id in varchar2) return varchar2 as ret varchar2(50); begin select f1||'|'||f2||'|'||f3 into ret from where id=p_id; return ret; exception when others then retrun '0'; end;
select text from user_source where type='PROCEDURE';
学习!select text from user_source where type='PROCEDURE';
select text from user_source where owner = 'YOURUSERNAME' and type='PROCEDURE';
return varchar2
as
ret varchar2(50);
begin
select f1||'|'||f2||'|'||f3 into ret from where id=p_id;
return ret;
exception
when others then
retrun '0';
end;