Oracle 临时表操作

--SESSION 结束就 DELETE
CREATE GLOBAL TEMPORARY TABLE tmp_foo(
    id NUMBER(10) NOT NULL,
    name VARCHAR2(32) NOT NULL,
    CONSTRAINT pk_foo_id PRIMARY KEY(id)
) ON COMMIT PRESERVE ROWS;                  --注意此处

--操作 1
INSERT INTO tmp_foo VALUES(1,'kerry');
SELECT * FROM tmp_foo;
--操作 2
COMMIT;
INSERT INTO tmp_foo VALUES(2,'rouce');
--操作 3
ROLLBACK;
SELECT * FROM tmp_foo;
--操作 4
COMMIT;
TRUNCATE TABLE tmp_foo;
--操作 5
DROP TABLE tmp_foo;

--COMMIT 就 DELETE
CREATE GLOBAL TEMPORARY TABLE tmp_bar(
    id NUMBER(10) NOT NULL,
    name VARCHAR2(32) NOT NULL,
    CONSTRAINT pk_bar_id PRIMARY KEY(id)
) ON COMMIT DELETE ROWS;                    --注意此处

--操作 1
INSERT INTO tmp_bar VALUES(1,'kerry');
SELECT * FROM tmp_bar;
--操作 2
COMMIT;
SELECT * FROM tmp_bar;
--操作 3
TRUNCATE TABLE tmp_bar;
--操作 4
DROP TABLE tmp_bar;