Xref: alice comp.databases.oracle.server:39578
Path: alice!news-feed.fnsi.net!hammer.uoregon.edu!logbridge.uoregon.edu!newsgate.cuhk.edu.hk!newsfeeder.ust.hk!news.ust.hk!engsvr.ust.hk!cswcc94
From: cswcc94@engsvr.ust.hk (Wong Chi Chung)
Newsgroups: comp.databases.oracle.server
Subject: Re: Temp Tables
Date: 2 Feb 1999 17:44:36 GMT
Organization: School of Engineering
Lines: 20
Message-ID: <797di4$dbd@ustsu10.ust.hk>
References: <787g1u$e7i$1@news1.fast.net>
X-Newsreader: TIN [version 1.2 PL2]

John Becker (jbecker2@ix.netcom.com) wrote:
: Sorry up front for this question, if it appears stupid, but...

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

: Thanks in Advance,
: John