oracle语句查找所有的视图和存储过程名称
---------存储过程名称
select distinct name from user_source where type = 'PROCEDURE'
---------视图名称
select view_name from user_views;
---------存储过程名称
select distinct name from user_source where type = 'PROCEDURE'
---------视图名称
select view_name from user_views;