Re: The equivalent of sp_helptext in Oracle??

From: Sybrand Bakker <gooiditweg_at_sybrandb.demon.nl>
Date: Wed, 04 Dec 2002 00:18:29 +0100
Message-ID: <tsequusmk2nins8gqt04t11apg3ogfdrbv@4ax.com>

On Tue, 03 Dec 2002 21:43:34 GMT, "gamaz" <gamaz_at_eathlink.net> wrote:

>Hi,
>I need to get the texts of all stored procedure, triggers and packages of
>one user. What would
>be the best way to handle this? I know in sql server, I used to use the
>sp_helptext command.
>Any help is appreciated in advance. Thanks.
>
>

Refer to user_source.
I guess you consistently refuse to read manuals, do you?

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Tue Dec 03 2002 - 17:18:29 CST