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 ?
look at the view "USER_SOURCE". The colume "name" corresponds to the
procedure name, "text" is the source code & ordering your output by "line"
means you get it in the right order. Having said that, I've so far noticed
that getting the rows in default order seems to be alright most of the time.
hpcheong_at_ncs.com.sg wrote in message <6tl25h$2m0$1_at_nnrp1.dejanews.com>...
>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:29:36 CDT