Re: Script Needed

From: <tjmxyz_at_my-deja.com>
Date: Fri, 17 Sep 1999 07:20:22 GMT
Message-ID: <7rsq3g$o3j$1@nnrp1.deja.com>

No but....

The query is simple.

try something like
SELECT text FROM all_source
WHERE type in ('PROCEDURE');
spool off

that should get you started.

In article <HjdE3.15036$N77.1116565_at_typ11.nn.bcandid.com>, "Van Messner" <vmessner_at_netaxis.com> wrote:
> I'm looking for a script to export the text of stored procedures,
packages,
> triggers etc. that can be run from SQL*Plus when I don't have access
to SQL
> Navigator or some other third party tool. Anybody have one they can
post?
>
> Thanks,
>
> Van
>
>

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Fri Sep 17 1999 - 02:20:22 CDT