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: How do I see the source code of a stored procedure through Sql*plus ?

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

From: Marcus N Hofer <markus_at_tk136248.telekabel.at>
Date: Thu, 18 Mar 1999 06:59:46 GMT
Message-ID: <Cv1I2.6394$_k1.2986@news.chello.at>


for instance

select text from user_source
where name = 'GLD_MAIN'
and type = 'PACKAGE' -- if it is a package! order by line;

have fun,
--marcus

sreeramav_at_my-dejanews.com schrieb in Nachricht <7cmf3u$qdv$1_at_nnrp1.dejanews.com>...
>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
Received on Thu Mar 18 1999 - 00:59:46 CST

Original text of this message

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