SQL> SELECT COUNT(*) FROM PART
2 WHERE PRIMARY_LOC_ID='FINAL'
3 / COUNT(*)
----------
6145SQL> INSERT INTO BAO_TEMP
2 SELECT ID , PRODUCT_CODE FROM PART
3 WHERE PRIMARY_LOC_ID='FINAL'
4 /建立了 6145 列目前歷時: 00:00:00.35我插入6145條記錄隻需要0.35秒!樓主你最好把具體 的語句貼出來大家一起看看
2 WHERE PRIMARY_LOC_ID='FINAL'
3 / COUNT(*)
----------
6145SQL> INSERT INTO BAO_TEMP
2 SELECT ID , PRODUCT_CODE FROM PART
3 WHERE PRIMARY_LOC_ID='FINAL'
4 /建立了 6145 列目前歷時: 00:00:00.35我插入6145條記錄隻需要0.35秒!樓主你最好把具體 的語句貼出來大家一起看看
我的存储过程如下:
create or replace procedure proc_a is
begin
insert into a select * from a;
end proc_a;下面是我执行的结果:
SQL> select count(*) from a; COUNT(*)
----------
32768已用时间: 00: 00: 00.00
SQL> exec proc_aPL/SQL 过程已成功完成。已用时间: 00: 00: 00.02
SQL> insert into a select * from a;已创建65536行。已用时间: 00: 00: 00.04
SQL> select count(*) from a; COUNT(*)
----------
131072 已用时间: 00: 00: 00.00
SQL> spool off
IF I_RECIPACC IS NULL THEN
IF I_SAMT IS NULL AND I_BAMT IS NULL THEN
DBMS_OUTPUT.PUT_LINE(to_char(sysdate,'hh:mi:ss'));
DBMS_OUTPUT.PUT_LINE(V_ACCNO);
DBMS_OUTPUT.PUT_LINE(V_BEGINDATE);
DBMS_OUTPUT.PUT_LINE(V_ENDDATE);
DBMS_OUTPUT.PUT_LINE(I_SAMT);
DBMS_OUTPUT.PUT_LINE(I_BAMT);
insert into rpt_nechdtl_result
select * from RPT_NECHDTL
WHERE ACCNO = V_ACCNO
AND BUSIDATE BETWEEN V_BEGINDATE AND V_ENDDATE
AND DRCRF >= '0'
AND AMOUNT >= I_SAMT
AND AMOUNT <= I_BAMT
--ORDER BY TIMESTMP DESC
;
DBMS_OUTPUT.PUT_LINE(to_char(sysdate,'hh:mi:ss'));
0301','20040330','0','-100000000000','100000000000');
08:45:41
1212121212121212121
01-MAR-04
30-MAR-04
-100000000000
100000000000
08:47:57PL/SQL procedure successfully completed.Elapsed: 00:02:16.95
select * 2 from RPT_NECHDTL
WH 3 ERE ACCNO = '1212121212121212121'
AN 4 D BUSIDATE BETWEEN to_date('20040301','yyyymmdd') AND to
_date('20040330','yyyymmdd')
5 AND DRCRF >= '0'
A 6 ND AMOUNT >= '-100000000000'
AN 7 D AMOUNT <= '100000000000'
8 ;8 rows created.Elapsed: 00:00:00.01
enddate也是一样