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