Files
oracle/tpt/lotstempios.sql
2026-03-12 21:23:47 +01:00

5 lines
198 B
SQL

CREATE GLOBAL TEMPORARY TABLE lotstempios ON COMMIT DELETE ROWS AS SELECT * FROM dual WHERE 1=0;
EXEC LOOP INSERT /*+ APPEND */ INTO lotstempios SELECT * FROM dual; COMMIT WRITE NOWAIT; END LOOP;