Xref: alice comp.databases.oracle.server:39601
Path: alice!news-feed.fnsi.net!news.idt.net!news-peer.gip.net!news-lond.gip.net!news.gsl.net!gip.net!newspeer.clara.net!news.clara.net!nnrp2.clara.net.POSTED!not-for-mail
From: "Iain McLaren" <imclaren@clara.net>
Subject: Re: Temp Tables
Newsgroups: comp.databases.oracle.server
References: <787g1u$e7i$1@news1.fast.net> <797di4$dbd@ustsu10.ust.hk>
Message-ID: <01be4ee6$ac58d4e0$LocalHost@carrot>
X-Newsreader: Microsoft Internet News 4.70.1155
Lines: 31
Date: Tue, 02 Feb 1999 19:55:50 GMT
X-Complaints-To: abuse@clara.net
X-Trace: nnrp2.clara.net 917985350 195.8.78.148 (Tue, 02 Feb 1999 19:55:50 BST)
NNTP-Posting-Date: Tue, 02 Feb 1999 19:55:50 BST


Hi,

> : I have a lot of experience with SQL Server, but am just starting with
> : Oracle.  In SQL Server, you can designate a table as temporary by
prefacing
> : the table name with a:
> : #    - meaning table's life span's the active connection, and is
visible
> : only to the active connection,
> :         - or -
> : ## - meaning table's life span's the active connection, and is visible
to
> : all other active connections
> 
> : Is there anything similiar in Oracle?  I have seen the the temporary
> : tablespace designator, but it seems as though management of any objects
> : created within is up to the user.

The closest thing in Oracle is the PL/SQL table. Which is an in memory
table, however
these can't be manipulated in the same way as a conventional database
table.

Cheers,

Iain.
-----
Iain McLaren
email: imclaren@clara.net
http://home.clara.net/imclaren