Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Viewing code in stored procedures and functions
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
--- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.454 / Virus Database: 253 - Release Date: 10/02/2003Received on Thu Feb 27 2003 - 04:52:04 CST