从数据字典中查询存储过程, 函数, 包

--查询存储过程

--select * from user_source order by name;

clear;

select * from user_source where name = 'ADD_USER_INFORMATION';

 

--查询函数:

--var sname = upper('get_sal');

--select * from user_source where name = 'GET_SAL';

select * from user_source where upper(name)= upper('get_sal');

 

--查询包：

select * from user_source where upper(name)=upper('pack_test') and upper(type) = upper('package');

 

--删除存储过程：

drop procedure add_user_information;  --

--删除函数：

drop function get_val;

--删除包：

drop package pack_test;   --package_name

drop package body pack_name; --package_name