Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Temp Tables
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.