Re: 'temp' oracle tables

Lun Wing San (Oracle) wrote:
>
> Gopal wrote:
> >
> > I would like to find out about how to create and user 'temp' tables
> > in Oracle in a manner similar to SQL Server. In SQL Server
> > it is possible to create temp tables in a stored procedure and this
> > table is only visible to that procedure and dies after the
> > procedure completes.
>
> There is no temporary table in Oracle.
>
> Name : Lun Wing San (Certified Oracle Database Administrator)

While there is no temp table, you can create a table in a session and use it, and then delete it, and as long as you don't do a commit before the delete, then the table will only be visible to that session.

sort of a hack...

Randy :) Received on Sun Apr 13 1997 - 00:00:00 CDT