oracle查看创建了哪些存储过程,oracle查看存储过程的内容

查看当前用户：

select * from user_procedures;

或

select * from user_objects where object_type=‘PROCEDURE’;(一定要大写)

查看所有用户（注意有权限）

select * from all_procedures;

或

select * from all_objects where object_type=‘PROCEDURE’;

查看存储过程的内容

SELECT text FROM user_source WHERE NAME = ‘procedure_name’ ORDER BY line;