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

Home -> Community -> Usenet -> c.d.o.misc -> Re: Print a procedure text.

Re: Print a procedure text.

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Thu, 20 Dec 2001 22:01:05 +0100
Message-ID: <u24lk7erb1pp75@corp.supernews.com>

"SG" <Serguei_Goumeniouk_at_ca.ml.com> wrote in message news:3C22394F.3A5C84D0_at_ca.ml.com...
> Dear Experts,
> How can I print out a text of a stored procedure?
> Regards,
> Serguei.
>

select text
from user_source
where name = '<your name>'
order by line
/

Hth

--
Sybrand Bakker
Senior Oracle DBA

to reply remove '-verwijderdit' from my e-mail address
Received on Thu Dec 20 2001 - 15:01:05 CST

Original text of this message

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