oracle创建事务级别的临时表

-- Create table
create global temporary table TMP_TABLE
(
  id NUMBER(16) not null
)
on commit delete rows;
-- Create/Recreate primary, unique and foreign key constraints 
alter table TMP_TABLE
add constraint PK_TMP_TABLE primary key (ID);