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: get body of stored procedures and functions?

Re: get body of stored procedures and functions?

From: Shakespeare <whatsin_at_xs4all.nl>
Date: Wed, 15 Aug 2007 11:41:59 +0200
Message-ID: <46c2ca6f$0$233$e4fe514c@news.xs4all.nl>

"desheng" <xufaning_at_gmail.com> schreef in bericht news:1187170411.500430.49490_at_l22g2000prc.googlegroups.com...
> On Aug 15, 12:58 pm, Mark Harrison <m..._at_pixar.com> wrote:
>> How can I get the body of stored procedures and functions?
>> I would like to extract some documentation embedded in
>> the comments.
>>
>> Many TIA!
>> Mark
>>
>> --
>> Mark Harrison
>> Pixar Animation Studios
>
> select NAME,TYPE,LINE,TEXT from USER_SOURCE;
>

order by type, name, line

or use a tool to view/edit packages like Oracle SQL Developer, TOAD or plsql Developer

Shakespeare Received on Wed Aug 15 2007 - 04:41:59 CDT

Original text of this message

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