oracle 中有三张表查找oracle中的所有包，包体等

1.user_objects

2.user_arguments

3.user_object

需求：查找oracle中的所有包，包体等

 

select  distinct object_type from user_objects;
select *  from user_objectS where object_type= 'PACKAGE BODY';
SELECT * FROM user_arguments;
select  * from user_source where type='PACKAGE BODY';
select name from user_source where text like'%varchar2(%)%' AND type='PACKAGE BODY';
select name,text from user_source where LOWER(text) like '%varchar2(6)%'