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

Sybrand Bakker wrote:
>
> "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.)
> >
> Regrettably your (repeated) answer is incorrect. Oracle 8i does have global
> temporary tables.

Been working with 7.3 for 3 years now at work. Only just managed to install Personal Oracle 8i at home.

-- 
MikeC

Please reply to the group.