for procedure source you could query user_source
to describe the procedure you could use SQL> desc procedure_name
> ----------
> From: Alaa Mostafa[SMTP:alaa210_at_yahoo.com]
> Sent: Wednesday, September 25, 2002 3:37 PM
> To: LazyDBA.com Discussion
> Subject: How to display a precedure from sql plus
>
> Hi All
>
> We Create a precedure from sql plus , and we want to desplay it ?
>
> thanx
>
>
>
> _____
>
> Do you Yahoo!?
> New DSL Internet Access
> <http://rd.yahoo.com/evt=1207/*http://sbc.yahoo.com/> from SBC & Yahoo!
>
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Rahul
INET: rahul_at_ratelindo.co.id
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Received on Wed Sep 25 2002 - 04:53:22 CDT
