Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: how can I list procedure source
On Thu, 20 Jul 2000 07:22:21 +0100, "John Dunn" <JLDunn_at_ukgateway.net> wrote:
>how can i get the source of a pl/sql procedure or function, from sqlplus?
>
>John
>
>
select text
from user_source (or all_source)
where name = 'YOUR_FUNC/PROC_NAME'
and type = 'PROCEDURE BODY' (or PROCEDURE, for header, or FUNCTION)
order by line;
Received on Thu Jul 20 2000 - 00:00:00 CDT