aburker
06-04-2003, 03:59 AM
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
i know about dba_source but want to find an easier way
thx
|
Click to See Complete Forum and Search --> : view procedure names of packages aburker 06-04-2003, 03:59 AM 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 ales 06-04-2003, 04:06 AM In SQL*Plus, type "desc package_name". pando 06-04-2003, 07:45 AM 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' dbasupport.com
Copyright Internet.com Inc. All Rights Reserved. |