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

Rick,

you wanted something that "...only lives for the life of the session..."

So......you can save it in a text file, and execute it as many times as you like.

IF, however, that is not possible or desirable, there is really nothing wrong, bad, non-performant, or deviant about using a stored procedure. <G>

After, all, if you DO intend to run it again, you can pin it and save some parse effort.

And if you DON'T intend to run it again, the anonymous PL/SQL you write need not be stored in a file!

Of course, you can always migrate to SQLServer, and use Transact-SQL. Yippee!

hth

• Ross "oracle rules, baby" Mohan

p.s. I *do* think SS2K will likely take over the world, but i'll

	be with Mladen, up on the ramparts, fighting all the way, 
	with the veins of other dbms' DBAs in my teeth. 

-----Original Message-----
From: Cale, Rick T (Richard) [mailto:RICHARD.T.CALE_at_saic.com] Sent: Tuesday, October 17, 2000 12:20 PM To: Multiple recipients of list ORACLE-L Subject: 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).

-- 
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