在PL/SQL中如何执行多条INSERT 语句？

[gerrycen]

INSERT INTO unicom.gsm_list SELECT CALLTYPE,ACCESS_NUMBER,CALLED_NUMBER FROM GSM_USAGE_CHARGE_TABLE_200303@server10 WHERE access_number like '1317791%' and CREATED_DATE>=to_date('20030313','yyyymmdd') and CREATED_DATE<=to_date('20030319','yyyymmdd')
INSERT INTO unicom.gsm_list SELECT CALLTYPE,ACCESS_NUMBER,CALLED_NUMBER FROM GSM_USAGE_CHARGE_TABLE_200303@server10 WHERE access_number like '1318456%' and CREATED_DATE>=to_date('20030313','yyyymmdd') and CREATED_DATE<=to_date('20030319','yyyymmdd')


单条可以执行，但是放在一起会报错，字符无效，加了分号也不行，说语句未正确结束，
这是为什么？

[shahand]

没有加分号？

[cao_elsie]

做一个循环不就行了吗

[ssstar]

inert..../
.
.
.
insert.../

[cenlmmx]

用动态SQL, 在外面套一个循环.

[beckhambobo]

create procedure p_insert
as
begin
INSERT INTO unicom.gsm_list SELECT CALLTYPE,ACCESS_NUMBER,CALLED_NUMBER FROM GSM_USAGE_CHARGE_TABLE_200303@server10 WHERE access_number like '1317791%' and CREATED_DATE>=to_date('20030313','yyyymmdd') and CREATED_DATE<=to_date('20030319','yyyymmdd');
end;
/


begin
for i in 1..n loop
p_insert;
end loop;
end;
/

[kerisyml]

作一个存储过程
或在Oracle自带的SQL WorkSheet里面运行

[wuque007]

编写一个脚本然后再sql*plus worksheet里运行本地脚本就行~~~~~~~~~~

[czmy007]

在OEM的工具SQLPLUS WORKSHEET 中可以运行。