Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: The equivalent of sp_helptext in Oracle??

Re: The equivalent of sp_helptext in Oracle??

From: gamaz <gamaz_at_eathlink.net>
Date: Wed, 04 Dec 2002 00:46:42 GMT
Message-ID: <SfcH9.2990$hM3.352350@newsread2.prod.itd.earthlink.net>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US