GLOBAL TEMPORARY TABLE in oracle

CREATE GLOBAL TEMPORARY TABLE UPDATE_TABLE(NEW_ID NUMBER,OLD_ID NUMBER) on commit preserve rows

SELECT * FROM update_table

SELECT EMP.ID,EMP.LASTID FROM EMPLOYEE EMP WHERE ID IN (SELECT NEW_ID FROM update_table)


/* updating status=1 from temporary table */

UPDATE EMPLOYEE EMP  SET EMP.status=1 WHERE ID IN (SELECT OLD_ID FROM update_table)

COMMIT;