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: Henning Follmann <henning_at_odin.follmann-net>
Date: Fri, 14 Sep 2001 09:44:02 -0400
Message-ID: <slrn9q3uqf.g6.henning@odin.follmann-net>


On Thu, 13 Sep 2001 14:44:26 -0400, Vincent Ventrone <vav_at_brandeis.edu> wrote:
>try "select text from dba_source where owner=<owner> and name=<name> and
>type='PROCEDURE';"

for a better readability:
order by line.
>
>"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??
>>

henning

-- 
Henning Follmann
8 Jane Road
New Providence, NJ 07974
Tel.: +1 908 656 7061
H.Follmann_at_gmx.de


-----=  Posted via Newsfeeds.Com, Uncensored Usenet News  =-----
http://www.newsfeeds.com - The #1 Newsgroup Service in the World!
 Check out our new Unlimited Server. No Download or Time Limits!
-----==  Over 80,000 Newsgroups - 19 Different Servers!  ==-----
Received on Fri Sep 14 2001 - 08:44:02 CDT

Original text of this message

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