select * from USER_SOURCE
where name in(
select object_name
from user_objects
where object_type = 'PACKAGE'
)
order by name, type,line
;
select *
from user_objects
--where object_type = 'PACKAGE'
where object_type = 'TABLE'
;
대충 확인만 한 쿼리라 만들때 확인이 필요함.. ^^