Re: Is an Oracle View the equivalent of an SQL server Temporary Table?

Dave Sutton wrote:
>
> Hi,
>
> I'm new to Oracle and am getting a bit confused over trying to create a
> temporary table.

Oracle does not have the #Temp temporary table feature of SQL Server.

> Can anyone tell me how to create a temporary table in Oracle...ie. used for
> the duration of a query only and then automatically discarded....is a
> temporary table actually a view?

Sybase and Microsoft SQL Server have this feature. Oracle doesn't.

-- 
MikeC

Please reply to the group.