Re: Printing Procedures

From: Alex Shnir <shnira_at_staff.juno.com>
Date: Thu, 05 Aug 1999 16:38:32 -0400
Message-ID: <37A9F648.A02DB89F@staff.juno.com>

SQL> desc all_source

 Name                            Null?    Type
 ------------------------------- -------- ----
 OWNER                           NOT NULL VARCHAR2(30)
 NAME                            NOT NULL VARCHAR2(30)
 TYPE                                     VARCHAR2(12)
 LINE                            NOT NULL NUMBER
 TEXT                                     VARCHAR2(2000)

select name, text from all_source
where type in ('PROCEDURE', 'FUNCTION') and owner = '....'

amerar_at_ci.chi.il.us wrote:

> Hello,
>
> I need to save the source all my stored procedures and functions to my
> Unix box. What view or table can I access to get this information?
>
> Thanks,
>
> Arthur
>
> Sent via Deja.com http://www.deja.com/
> Share what you know. Learn what you don't.
Received on Thu Aug 05 1999 - 15:38:32 CDT