oralce导入含大量的SQL文件
sql.sql文件:
--------------------------------文件内容
set feedback off
set define off
?
insert into test(id,num,name_,money) values(gan.nextval,'Z0350012C','裝飾帽','??? -2,700.00');
insert into test(id,num,name_,money) values(gan.nextval,'Z-14','磨砂杯','');
commit;
insert into test(id,num,name_,money) values(gan.nextval,'Z0350012C','裝飾帽','??? -2,700.00');
insert into test(id,num,name_,money) values(gan.nextval,'Z-14','磨砂杯','');
-----------------------------------
commit;
insert into test(id,num,name_,money) values(gan.nextval,'Z0350012C','裝飾帽','??? -2,700.00');
insert into test(id,num,name_,money) values(gan.nextval,'Z-14','磨砂杯','');
-----------------------------------
commit ;
set feedback on
set define on
?
--------------------------------/文件内容结束
?
在pl/sql里打开command window----->敲入命令"@file=:\a.sql"