I have using Oracle GTT tables with condition ON COMMIT DELETE ROWS.
Now i know GTT tables data is only session specific. 1 session cannot see the GTT data of other session in General.
But is their any way to access/read GTT table that belongs to another session?
Best Answer
No that is not possible, only session accessing the GTT can see it. IF you wish, you can use a physical table and model it as if it s a GTT. It isn't difficult, but isn't very efficient either.