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

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Tue, 26 Dec 2000 22:28:59 +0100
Message-ID: <92b3ar$6f61v$1@ID-62141.news.dfncis.de>

"Michael Carton" <MikeC_at_erols.com> wrote in message news:3A48DF6D.6922CBE7_at_erols.com...
> Barbara Kennedy wrote:
> >
> > No. think of a view as a predefined query that you can issue queries
> > against. I believe in SQL Server that views when they have queries
executed
> > against them create a temporary table and then the query is executed
against
> > that.
>
> That's not true. SQL Server views operate like Oracle views. The original
poster
> was looking for a SQL Server feature that's not present in Oracle (and he
was
> confused, to boot.)
>
> --
> MikeC
>
> Please reply to the group.

Regrettably your (repeated) answer is incorrect. Oracle 8i does have global temporary tables.

Regards,

Sybrand Bakker, Oracle DBA Received on Tue Dec 26 2000 - 15:28:59 CST