Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Is an Oracle View the equivalent of an SQL server Temporary Table?
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:11:35 CST