"(Pete Cresswell)" <x_at_y.z> wrote in message
news:7dvumv0n9nef438hgrfc1fea9c8ejf1sah_at_4ax.com...
> RE/
> >Personally, I think you are going to find that the person who wants temp
> >tables probably is from a non-Oracle background (eg Sybase or SQLServer)
> >where they are used all the time for a variety of reasons.
>
> Bingo!.... SQL Server...
> -----------------------
> PeteCresswell
I'd expect in a lot of cases you won't even need a GTT. In MSSQL you might
well wish temp tables to avoid locking issues, in Oracle you won't get those
locking issues.
--
Niall Litchfield
Oracle DBA
Audit Commission UK
Received on Wed Sep 24 2003 - 05:54:26 CDT
