Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Package question.
Stephen wrote:
>
> Hello all,
>
> I have a question about package.
> How to list the content of the package? When I type "select * from
> dba_object_size", it can show the package and its owner. But how can I
> know the content of the particular package?
>
> Moreover, is the package can be used by its owner? If so, how can grant
> the privilege to other users?
>
> Thanks,
> Stephen
You can get the package and package body containts from the all_source table.
select text
from all_source
where type in ('PACKAGE','PACKAGE BODY')
and name = package_name
order by line
Vijay Darekar Received on Sun Aug 24 1997 - 00:00:00 CDT