Oracle 创建临时表

CREATE GLOBAL TEMPORARY table DAT_TEST_BOM4(2,4)
                     (
                         TREE_ID NUMBER,
                         PART_ID NUMBER,
                         PART_NO VARCHAR2(20),
                         PID     VARCHAR2(20),
                         BOM_ID  NUMBER
                   )on commit preserve rows;
                  
CREATE global TEMPORARY table DAT_TEST_BOM3
                     (
                         TREE_ID NUMBER,
                         PART_ID NUMBER,
                         PART_NO VARCHAR2(20),
                         PID     VARCHAR2(20),
                         BOM_ID  NUMBER
                   )on commit preserve rows;
                  
create global temporary table TERT_CURRENT_ORDERINFO
(
  ORDER_TYPE    VARCHAR2(20),
  ORDER_NO      VARCHAR2(25),
  DEPT_NAME     VARCHAR2(30),
  WO_START_DATE DATE,
  TERS          VARCHAR2(20)
) ON COMMIT PRESERVE ROWS;