Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: view store procedures
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
![]() |
![]() |