查看用户所有的存储过程:
select object_name from users_object where object_type='PROCEDURE';
查看存储过程源码:
select text from user_source where type='PROCEDURE' and name='PROCEDURE_NAME';
select object_name from users_object where object_type='PROCEDURE';
查看存储过程源码:
select text from user_source where type='PROCEDURE' and name='PROCEDURE_NAME';