Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Peeking in on Stored Procedures

Re: Peeking in on Stored Procedures

From: C. Ferguson <c_ferguson_at_rationalconcepts.com>
Date: Fri, 01 Sep 2000 04:27:37 GMT
Message-ID: <39AF307B.7529600F@rationalconcepts.com>

in sqlplus,
 sql> desc all_source
or
 sql> desc user_source

Then select what is appropriate from either.

hth,
cindy

jgotthelf_at_my-deja.com wrote:

> Hi,
>
> How does one see the code of a stored procedure from SQL+. I know how
> to do this from Enterprise Manager, but quite frankly, that beast is a
> bit unwieldy, and teaches me nothing - in addition to screwing things
> up on occasion!
>
> Joe G.
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Thu Aug 31 2000 - 23:27:37 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US