You can use following query to find procedures and function names defined in a Package:
select distinct object_name from all_arguments where package_name = 'package_name';
To find the entire source you can use:
select text from user_source WHERE type = 'PACKAGE' and name='package_name';
Friday, January 25, 2008
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment