查看当前用户：
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;