Re: PL/SQL Tip of the Month

info_at_revealnet.com wrote:

> Have you ever wondered how you can get a list of the names of the procedures
> and functions in your package? The data dictionary does not, unfortunately,
> offer a view that contains the list of elements defined in a package
> specification (that would be so incredibly useful!). There are, however, a
> couple of ways to get at this information.

Speaking of which,does anyone know a way to export the *packages* (+proc's, functions) of a *user*
and only the packages (so no tables, not even the empty versions of them) ? This in a way that these can be imported in another database (so without exporting
the whole database).

A lead to a solution is also welcome.

Thanks in advance,

r u d i
(remove anti-spam measure from reply-address) Received on Thu May 07 1998 - 00:00:00 CDT