Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> PLEASE HELP : Global Temp Table Weird Behavior...
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:43:37 CDT