Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Is Package Information Stored in an ALL_* Table?
I would like to query the database for package information - namely the names of all the functions or procedures that are part of my package definition.
For example, if I have a package...
CREATE PACKAGE PKG1 AS...
PROCEDURE update_names (...
PROCEDURE update_appointments (...
FUNCTION get_order_date (...
etc.
END PKG1;
I would like to query for...
update_names
update_appointments
get_order_date
etc.
Is there an ALL_ table that stores this information? Thanks in advance...
B~ Received on Mon Jan 22 2001 - 19:26:14 CST