all_arguments

by Granville Bonyata on January 16, 2012

all_arguments contains the parameters for all procedures and functions (including within packages).

An example is finding all Oracle built-in functions (that are part of the STANDARD package):

select distinct object_name
from all_arguments
where package_name = ‘STANDARD’
order by 1;

Next post: