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: Niall Litchfield <n-litchfield_at_audit-commission.gov.uk>
Date: Fri, 11 Apr 2003 15:08:53 +0100
Message-ID: <3e96cc7b$0$29711$ed9e5944@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 ;



--
Niall Litchfield
Oracle DBA
Audit Commission UK


Received on Fri Apr 11 2003 - 09:08:53 CDT












Original text of this message













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