oracle sp中用临时表的方法。

先生成临时表TEMP1:

CREATE GLOBAL TEMPORARY TABLE TEMP1

(
  TOPN       NUMBER,
  HA0IA_EA   VARCHAR2(2 BYTE),
  HA0ORIGIN  VARCHAR2(6 BYTE),
  CUSTCODE   VARCHAR2(30 BYTE),
  CUST0NAME  VARCHAR2(90 BYTE),
  HAWB       NUMBER,
  DS         NUMBER,
  CW         NUMBER,
  REVENUE    NUMBER,
  COST       NUMBER
)

ON COMMIT PRESERVE ROWS;

再sp中写

v_temp1  varchar2(12700); 

delete from TEMP1;
    v_temp1 := ' INSERT INTO TEMP1(SELECT * from table1 )';
    execute immediate v_temp1;
     delete from TEMP1;
    commit;