Re: Temporary Table Howto

From: <andreas.prusch_at_sintec.de>
Date: Fri, 22 May 1998 06:22:37 GMT
Message-ID: <6k35jd$i6i$1@nnrp1.dejanews.com>

There are no temporary tables in Oracle like those in Informix. In some cases you can use inline queries (select * from (select a.c1,b.c2, sum(c3) from a,b group by a.c1, b.c2)) to have the same result. Another way is to create the tables with <sid>_TableName. Because Oracle reuse the sid's you only have to truncate the table when you terminate the session. So you have no implicit commit, when you use the "temporary table" first in contrast to use the create table command.

In article <3563569F.9AE05C5E_at_home.com>, gmyers_at_home.com wrote:
>
> I've used Informix temp tables which are identified using a specific
> naming convention and are accessible only to the creating
> session for the lifetime of the session and when you logout the table
> disappears.
>
> If I create an ORACLE table in a temporary tablespace does it behave
> the same way. ORACLE's documentation on temporary tables is not clear.
> I'd appreciate a pointer or an email example.
>
> TIA
> George
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Fri May 22 1998 - 01:22:37 CDT