Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: get body of stored procedures and functions?
"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