Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: view store procedures

Re: view store procedures

From: Vincent Ventrone <vav_at_brandeis.edu>
Date: Thu, 13 Sep 2001 14:44:26 -0400
Message-ID: <9nquiv$avv$1@new-news.cc.brandeis.edu> 





try "select text from dba_source where owner=<owner> and name=<name> and
type='PROCEDURE';"



"WKC" <wkchen_at_bigfoot.com> wrote in message
news:_l4o7.14575$A5.2749588_at_typhoon.nyc.rr.com...


> I'm able logon to oracle 8.0 using sqlplus.  How can I list all store

> procedures and look at individual source code of each store procedures??

>

> anyone can help?

>

> -Ken

>

>

Received on Thu Sep 13 2001 - 13:44:26 CDT












Original text of this message













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