Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: PL/SQL Tip of the Month

Re: PL/SQL Tip of the Month

From: Rudi Demeulenaere <rdm_at_mentor.spamnothanks.be>
Date: 1998/05/07
Message-ID: <3552186E.882EAB89@mentor.spamnothanks.be>#1/1

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US