Well, let's see on how to create global temp tables in oracle .

CREATE GLOBAL TEMPORARY TABLE "TMP_TABLE" ( "Column" NUMBER(38) NOT NULL ENABLE ) ;

That would create a gloabal temp table for you. In case you want to handle the data and retain it only for the transaction, then append the following line
"ON COMMIT DELETE ROWS".

And if you want to retain the data for the entire session , then use the below line

"ON COMMIT PRESERVE ROWS".

Well , thats it for this session. In case, you have any question , let me know.

Thanks!!!

Well, this is my first blog ever created. Will try to go through the coding/technical challenges and figure out a possible solution for the same.

A heartly welcome to all the members and visitors

Thanks !!!!