Envelope-to: oracle-l@orafaq.net
Delivery-date: Wed, 25 Sep 2002 17:34:07 +0800
Message-ID: <F001.004D899B.20020925015322@fatcity.com>
Date: Wed, 25 Sep 2002 01:53:22 -0800
To: Multiple recipients of list ORACLE-L <ORACLE-L@fatcity.com>
Sender: root@fatcity.com
Reply-To: ORACLE-L@fatcity.com
Errors-To: ML-ERRORS@fatcity.com
From: Rahul <rahul@ratelindo.co.id>
Subject: RE: How to display a precedure from sql plus
Organization: Fat City Network Services, San Diego, California
Precedence: bulk
Mime-Version: 1.0
Content-Type: text/plain
Content-Transfer-Encoding: 7bit

for procedure source you could query user_source 
to describe the procedure you could use SQL> desc procedure_name


> ----------
> From: 	Alaa Mostafa[SMTP:alaa210@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@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@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).