Re: Help with Temporary Tables

From: Sebastian Bienkiewicz <bienkiew_at_bph.krakow.pl>
Date: Tue, 20 Apr 1999 12:08:12 +0200
Message-ID: <371C520C.9A400BCD@bph.krakow.pl>

> Please correct me if I'm wrong, but it seems Oracle does not support this.
> A temporary table is just a normal table which you create and drop during a
> session. This means there will be naming conflicts when multiple copies of
> the same code are run.

Yes, it's true. Temp tables will be supported from 8.1 version.

>
> Is there a simple solution to this problem? Otherwise I guess I'll have to
> create a random number and append it to the table name each time it's
> created.

For example.

Regards,
Sebastian. Received on Tue Apr 20 1999 - 05:08:12 CDT