on commit delete rows 发表于 2014-07-16 由 小样儿 -- Create table create global temporary table TABLE_TMP ( R1 VARCHAR2(20), R2 NUMBER(16,2) ) on commit delete rows;