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

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.