Re: PLEASE HELP : Global Temp Table Weird Behavior...

From: R Chin <rchin_at_panix.com>
Date: Wed, 29 May 2002 12:50:53 -0400
Message-ID: <ad30n7$9d7$1@reader1.panix.com>

Sorry the GTT is transaction-based NOT session (...on commit delete)
so my_tab in the SQL below is a GTT

Session-based GTT seems to be OK but
it seems one can not use ROWID with the transaction-based GTT as fully as with normal table

Please confirm thanks !
Rob

R Chin wrote in message ...
>Is there a difference in how normal table and global temp table (session)
>behave
>when it comes to using ROWID in SQL ???
>
>The following returns diff result (GTT returns nothing)...try it yourself !
>
> UPDATE my_tab
> SET note = 'MULTI-REC'
> WHERE ROWID IN
> (SELECT ROWID
> FROM my_tab y
> WHERE code > (SELECT MIN(code)
> FROM my_tab x
> WHERE x.PK = y.PK));
>
>or just the SELECT:
>
>SELECT ROWID
> FROM my_tab y
> WHERE code > (SELECT MIN(code)
> FROM my_tab x
> WHERE x.PK = y.PK)
>
>GTT returns nothing ! What gives ????
>
>
>
>
Received on Wed May 29 2002 - 11:50:53 CDT