查询SCOTT用户下的存储过程 方法一: select * from user_procedures; 方法二: select object_name,object_type,procedure_name from dba_procedures where object_type='PROCEDURE' and owner='SCOTT';本回答被提问者和网友采纳
第2个回答 2016-01-13
select * from user_objects where object_type='PROCEDURE'