| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: SQL Command to view stored procedure
>-----Original Message-----
>From: Webber Valerie H [mailto:Valerie.H.Webber_at_irs.gov]
>
>What is the SQL command, v$ table or SQL*Plus command to
>see the contents of a stored
>procedure?
>I looked at DBA_SOURCE but it stored the code in
> separate rows based on the owner and procedure name.
You can use dba_source
select text
from dba_source
where owner = 'PROCEDURE_OWNER'
and name = 'PROCEDURE_NAME'
order by type, line ;
Received on Tue Apr 03 2001 - 15:25:11 CDT
 |
 |