Does anybody can tell me to find out the procedures available in a packages.
Ex: I know the package name like DBMS_SQL.
I would like to know the procedures which is available under the packages
Thankx
M.Jeyaseelan
Printable View
Does anybody can tell me to find out the procedures available in a packages.
Ex: I know the package name like DBMS_SQL.
I would like to know the procedures which is available under the packages
Thankx
M.Jeyaseelan
In SQL*PLus Release 8 you can use DESC:
DESC your_package
Or you can use ALL_SOURCE view:
SELECT text
FROM all_source
WHERE type = 'PACKAGE'
AND name = 'YOUR_PACKAGE'
ORDER BY line;