Re: Where is TEMP TABLE created?

From: Jim Kennedy <kennedy-downwithspammersfamily_at_attbi.net>
Date: Mon, 25 Jul 2005 06:25:33 -0700
Message-ID: <O8CdnX2I4uiXdXnfRVn-jg@comcast.com>

"Ken" <ken_at_kk.int> wrote in message news:42e4a324_3_at_rain.i-cable.com...
> > If you think you need something else: In Oracle you only rarely need
> > temporary tables.
> >
> Hi Mr Bakker,
>
> Why? Could you elaborate more on this.
>
> Thx for your advice.
>
>

Because Oracle!=SQL Server. Readers don't block writers so you don't need to put stuff in temp tables like you do in SQL Server. Just use a query. Jim Received on Mon Jul 25 2005 - 08:25:33 CDT