Re: How do I see the source code of a stored procedure through Sql*plus ?

From: <rsthomas_666_at_my-dejanews.com>
Date: Thu, 18 Mar 1999 02:11:01 GMT
Message-ID: <7cpnbf$iu6$1@nnrp1.dejanews.com>

In article <7cp8e6$67a$1_at_nnrp1.dejanews.com>,   sundar_rr_at_my-dejanews.com wrote:
> In sql plus
> The table which stores the details of the stored procedures is ALL_SOURCE.
> This should be your query.
>
> Select TEXT
> from ALL_SOURCE
> where NAME = (your store procedure name).
>
> This should give you the source code.
>
> have fun....
>
> In article <7cmf2a$qdi$1_at_nnrp1.dejanews.com>,
> sreeramav_at_my-dejanews.com wrote:
> > How do I see the source code of a stored procedure through Sql*plus ?
> >
> > -----------== Posted via Deja News, The Discussion Network ==----------
> > http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
> >
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
>

well i guess u can query the DBA_SOURCE like this

SELECT text

FROM      SYS.DBA_SOURCE
WHERE     name='( Give the name of the procedure)'

ORDER BY line
/

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Wed Mar 17 1999 - 20:11:01 CST