---------存储过程名称
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;
转载于:https://www.cnblogs.com/xuuc/p/3616018.html