what is the difference between local and global temporary table in oracle?
A Local temporary table is defined by giving it a prefix of # and is scoped to the session in which you created it. Global temporary tables can be seen by all sessions connected to the server and are defined by a prefix of ##.