RE: list procedure code

select text from user_source

   where name = 'procname'
     and type = 'PROCEDURE'
   order by line;

> -----Original Message-----
> From: John Dunn [mailto:john.dunn_at_sefas.co.uk]
> Sent: 17 July, 2000 11:00 AM
> To: Multiple recipients of list ORACLE-L
> Subject: list procedure code
>
>
> How can I list the source code of a procedure from sqlplus?
>
Received on Mon Jul 17 2000 - 11:59:55 CDT