Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Temp Tables
There are PL/SQL table structures in Oracle which behave just like SQL/SERVER
temp. tables.
Wong Chi Chung wrote:
> John Becker (jbecker2_at_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
Received on Thu Feb 04 1999 - 16:24:44 CST