Re: Viewing code in stored procedures and functions

"Chris ( Val )" <chrisval_at_bigpond.com.au> schrieb im Newsbeitrag news:b3kqkh$1nv0qe$1_at_ID-110726.news.dfncis.de...
> Hi everyone.
>
> I have some stored procedures, and I haven't been able to
> find out how to view the code for them properly. What I
> mean by that is, when I use the following command in SQL*PLUS:
>
> SELECT TEXT FROM USER_SOURCE MyProcedure;
>
> ... I get a listing of the code for *all* my procedures.
>
> Is there a way that I can just view the code for *MyProcedure*,
> only, without viewing screens full from all the others ?.
>
> Any and all advice welcome.
>
> Thanks.
> Chris Val

Hi Chris,

ever heard about the WHERE clause ;-) ?
Try this:
SELECT text FROM user_source
WHERE name = 'MYPROCEDURE' -- names are upper case by default ORDER BY line;

Does it look better?

hth and greetings,
Guido Received on Thu Feb 27 2003 - 05:02:16 CST