Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Newbie - How do I view Stored Procedure source?
"Niall Litchfield" <n-litchfield_at_audit-commission.gov.uk> wrote in message news:<3e96cc7b$0$29711$ed9e5944_at_reading.news.pipex.net>...
> "Ricky" <rforde48_at_hotmail.com> wrote in message
> news:609a5433.0304110533.58a254e6_at_posting.google.com...
> > Hi. I'm trying to figure out how I would view the source for a stored
> > procedure from SQL/Plus? Is there some kind of command?
>
> select text from user source where name ='<your proc name>' order by line ;
What is 'user source'? Received on Fri Apr 11 2003 - 13:48:59 CDT
![]() |
![]() |