Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How do I check for source code of my procedures ?
try
column text format a132
select text
from user_source
where name = 'YOUR_PROCEDURE_NAME'
and type = 'PROCEDURE'
order by line;
Regards,
K POON
hpcheong_at_ncs.com.sg wrote:
> hi,
>
> does anyone know how can i check for source code of my procedures at sqlplus?
> is it possible in the first place? if not, what can be the alternatives?
>
> i am using oracle 7.2.
>
> thanks in advance!
>
> rgds,
>
> evelyn.
>
> -----== Posted via Deja News, The Leader in Internet Discussion ==-----
> http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum
>
Received on Tue Sep 15 1998 - 07:40:54 CDT