Finding the list of procedures ....

[dearcyril]

Hi
How to find the list of procedures/function which come under a package created by a particular user


Thanks
 Cyril

[sibanjan]

Hi cynil,
   There are two ways by which we can find out the list according my knowledge.

1st one is by querying all_source data dictionary.

select * from all_source
where owner='HR'
and type='PACKAGE'

2nd  one is by querying all_procedures data dictionary.

select * from all_procedures
where upper(owner)='HR'
and upper(OBJECT_NAME)='xxcustompackage'