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

Jim,

Thanks for the reply. I can't believe how helpful you guys are on this board!

Unfortunately I'm having to use version 7.3.4. At least I know what's available to me now.

Many thanks.

Regards,

Dave

"Barbara Kennedy" <barbken_at_teleport.com> wrote in message news:TO7T5.13642$pZ1.805394_at_nntp3.onemain.com...
> 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. In Oracle a view is a query and when a query is issued against it
 is
> combines the two queries into one and executes that. In Oracle 8 you can
> create a temporary table, but I have never used one. It is a new feature
> and the best description is in the SQL Reference manual (available in HTML
> at otn.oracle.com or on your Oracle Distribution CD). You may not have to
> create a temporary table in Oracle like you do in SQL Server.
> Jim
> "Dave Sutton" <dpsutton_at_marchsystems.co.uk> wrote in message
> news:8viuau$3mr$1_at_newsreaderm1.core.theplanet.net...
> > Hi,
> >
> > I'm new to Oracle and am getting a bit confused over trying to create a
> > temporary table.
> >
> > 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?
> >
> > Thanks in advance.
> >
> >
> > Dave
> >
> >
>
>
Received on Thu Nov 23 2000 - 06:33:59 CST