--查询存储过程
--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