Oracle 10g (34) Oracle PL/SQL (12) Oracle SQL (9) SQL and PL/SQL (2) Subscribe to oracle tutorials. On commit fire, on complete transaction, data remain perserved in this it only lost at end of session or manually delete. Global temporary tables are distinct within SQL sessions. On commit fire it will complete transaction and table data is deleted.ĬREATE GLOBAL TEMPORARY TABLE TEST_TEMP (id NUMBER) ON COMMIT PRESERVE ROWS Only be removed at the end of the session or manually delete command.Įxample: Use of Clauses in Temporary table.ĬREATE GLOBAL TEMPORARY TABLE TEST_TEMP (id NUMBER) ON COMMIT DELETE ROWS Data is remain private at session level.Ĭlause make sure data deleted at the end of the transaction or the end of the session level.Ĭlause make sure data remain persistent at the end of the transaction. Oracle does not support Local Temporary table.
Temporary table is used to store data temporary for a session and utilized in single session or transaction as you needed and defined while creating Temporary table in Oracle.ġ. Global and local temporary table in Oracle
0 kommentar(er)
