oracle-temporary table

In Oracle, temporal tables are divided into session-level and transaction-level, and session-level temporal table data exists throughout the session until the end of the session, and the transaction-level temporary table data disappears after the transaction ends, that is, the Commit/rollback or end session clears the data.

-----------------------------------------------------------------------------------------------
--Establish a temporary table at the transaction level
--Delete a temporary table at the transaction level
drop table Admin_work_area

--Create a temporary table at the transaction level
CREATE GLOBAL Temporary TABLE Admin_work_area
(
StartDate DATE,
EndDate DATE,
Class CHAR (20))
On COMMIT DELETE ROWS;

--Inserting data
INSERT into Admin_work_area values (sysdate,sysdate, ' temperary table ');

--Querying the data
SELECT * from Admin_work_area;
--Commit (the data you just inserted will be emptied)
Commit
-------------------------------------------------------------------------------------------------

--Establish session-level staging tables
--delete session-level temporary tables
TRUNCATE TABLE Admin_work_area;
drop table Admin_work_area;

CREATE GLOBAL Temporary TABLE Admin_work_area
(
StartDate DATE,
EndDate DATE,
Class CHAR (20)
) on COMMIT PRESERVE ROWS;

--Inserting data
INSERT into Admin_work_area values (Sysdate,sysdate, ' session temperary ');

SELECT * from Admin_work_area;
--Submit (the data you just inserted is still there)
Commit

oracle-temporary table