Re: Script Needed

set linesize 300
set pagesize 0

spool filename

select text from user_source
where name = 'XXX' and type 'YYYY'
order by line;

spool off

roland schaar
gosch consulting gmbh

Van Messner 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
Received on Fri Sep 17 1999 - 04:07:43 CDT