查看当前用户:
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 * from user_tables;
或者
select * from user_objects where object_type='TABLE';