Re: Getting stored procedures using SQL

"Pål" wrote:

> Hi,
>
> Is it possible to get the stored procedures on the Oracle DB-server by using
> SQL? (Like: Select * from Procedure_table) ??
>
> -Pål-

SELECT text
FROM all_source
WHERE name = <name_of_the_procedure>
ORDER BY line;

Daniel Morgan Received on Mon Sep 16 2002 - 10:56:29 CDT