web analytics

How to list all the procedures and function defined in an Oracle package?

Options

codeling 1599 - 6654
@2016-10-13 08:56:52

The following PL/SQL statement can be used to list all the procedures and function defined in an Oracle package:

select  package_name, object_name,
decode(position,0,'FUNCTION','PROCEDURE') procedure
from ALL_arguments
where
package_name='YOURPACKAGE' and owner='YOUROWNER' and sequence=1

Comments

You must Sign In to comment on this topic.


© 2024 Digcode.com