Global Temporary Table
Global Temporary Table (GTT): Data base version: Oracle Database 11g Environment: DWH This kind of table defines a temporary table for the current connection, these tables do not reside in the system catalogues and are not persistent. Temporary tables exist only during the connection that declared them and cannot be referenced outside of that connection. When the connection closes, the table rows are deleted, and the table is dropped. Temporary tables are useful when: The table structure is not known before using an application Data in the temporary table is needed while using the application The table can be declared...