select * from dba_source where OWNER='用户名' AND TYPE='PROCEDURE' 转载于:https://www.cnblogs.com/wangdetian168/archive/2011/07/26/2117314.html