Re: Creating temporary tables that only exists during the query.

Let's answer the question another way: Why?

Oracle will create temporary segments as it needs them.

A table that was automatically dropped would be off no use to you, as you could never read from it.

A table that was dropped would suffer more overhead than one which was correctly sized and left where it is.

I'm completely at a loss as to what you are trying to achieve - maybe you could give us more detail?..

Look at PL/SQL tables (making them persistent in packages, if you need it) first, as this may be what you are looking for?

Steve Phelan.

Deryl Banuelos wrote in message
<01bd4cf6$cbee4da0$9c802192_at_banu-hou130-1.hou130.chevron.com>...
>Long ago when ships were tall and Oracle was 6.0 my instructor showed
>us a query example that created a temporary table that once the query was
>over the
>table was gone. I have an application request for such a procedure. Does
>anyone
>know how to create a temporary table through a sql with out having to issue
>a drop command when done with it?
>Thanks in advance.
>--
>Deryl Banuelos
>BANU_at_Chevron.com
Received on Wed Mar 11 1998 - 00:00:00 CST