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: Newbie - How do I view Stored Procedure source?

Re: Newbie - How do I view Stored Procedure source?

From: Ricky <rforde48_at_hotmail.com>
Date: 11 Apr 2003 11:48:59 -0700
Message-ID: <609a5433.0304111048.4187b4fa@posting.google.com>


"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

Original text of this message

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