RE: Is there anything in Oracle comparable to SQL server "private

Yeah that is what I thought, but you can only execute it once so really nothing EXACTLY
comparable.

Thanks
Rick

> -----Original Message-----
> From: Mohan, Ross [SMTP:Ross.Mohan_at_PictureVision.com]
> Sent: Tuesday, October 17, 2000 11:47 AM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Is there anything in Oracle comparable to SQL server
> "private
>
> plain old anonymous pl/sql blocks. just start typing, without "create
> or replace"
>
> BEGIN.....
>
> ...
>
> End;
> .
> /
>
>
>
>
>
>
> -----Original Message-----
> Sent: Tuesday, October 17, 2000 8:36 AM
> To: Multiple recipients of list ORACLE-L
> temporary store procedures"
>
>
> Hi DBAs,
>
> In SQL Server there are private temporary store procedures denoted by
> #create ....
> It only lives for the life of the session and can only be run by user
> creating it at least according
> to coworker. Is there anything comparable to this in Oracle.
>
> Thanks
> Rick
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Cale, Rick T (Richard)
> INET: RICHARD.T.CALE_at_saic.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Mohan, Ross
> INET: Ross.Mohan_at_PictureVision.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
Received on Tue Oct 17 2000 - 10:15:04 CDT