Re: viewing Stored Procedure Definition in SQL prompt
From: Vattekkat Satheesh Babu <vattekkat.babu_at_verizon.net>
Date: Wed, 03 Sep 2003 11:45:26 GMT
Message-ID: <pan.2003.09.03.11.45.29.754475_at_verizon.net>
ORDER BY
I.line
Date: Wed, 03 Sep 2003 11:45:26 GMT
Message-ID: <pan.2003.09.03.11.45.29.754475_at_verizon.net>
On Wed, 03 Sep 2003 01:49:03 -0700, Siva wrote:
> Hi,
>
> i would like to know the prcedure for viewing Stored Procedure
> Definition in SQL prompt. can anybody help me?
>
> thanxs & bye
SELECT
I.text
FROM
all_source I
WHERE I.type='PROCEDURE' AND I.name='YOUR_PROCEDURE_NAME' AND I.owner='SCHEMA_OWNER'
ORDER BY
I.line
You can get the source for FUNCTION, PACKAGE and PACKAGE BODY by changing type = 'xx'
- Babu http://vsbabu.org/