Temp Tables

From: John Becker <jbecker2_at_ix.netcom.com>
Date: Thu, 21 Jan 1999 10:19:09 -0500
Message-ID: <787g1u$e7i$1@news1.fast.net>

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 Received on Thu Jan 21 1999 - 09:19:09 CST