is there a method to list all procedures/functions of certain packages.
i know about dba_source but want to find an easier way
thx
Printable View
is there a method to list all procedures/functions of certain packages.
i know about dba_source but want to find an easier way
thx
In SQL*Plus, type "desc package_name".
for package´s proc & functions
select distinct object_name
from all_arguments
where package_name='DBMS_STATS';
for package´s procs & fncion´s arguments
select object_name, argument_name
from all_arguments
where package_name='DBMS_STATS'