Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: The equivalent of sp_helptext in Oracle??
Hey Sybrand,
Thanks for the help. I appreciate it.
"Sybrand Bakker" <gooiditweg_at_sybrandb.demon.nl> wrote in message
news:tsequusmk2nins8gqt04t11apg3ogfdrbv_at_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 - 18:46:42 CST