oracle 执行多条insert 语句

 

其实这是一个sqlserver的脚本改的。用脚本的原因是：当时我的oracle不能导入execl,也不能从别的数据库直接导入，最后就用脚本了。

insert all 
 INTO TestA (ID, tbname, colname, coltxt, collen, coltype, coloper, colcontent) VALUES('1', 'A主表', 'ZHD0A0001', '地方编号', '100', 'VARCHAR2', '主键', ' ')
 INTO TestA (ID, tbname, colname, coltxt, collen, coltype, coloper, colcontent ) VALUES('2', 'A主表', 'ZHD0A0002', '行政代码', '10', 'int', '数字', ' ')
 INTO TestA (ID, tbname, colname, coltxt, collen, coltype, coloper, colcontent) VALUES('3', 'A主表', 'ZHD0A0003', '野外编号', '50', 'VARCHAR2', ' ', ' '')
 INTO TestA (ID, tbname, colname, coltxt, collen, coltype, coloper, colcontent ) VALUES('4', 'A主表', 'ZHD0A0004', '图幅统一编号', '50', 'VARCHAR2', ' ', ' ')
 INTO TestA (ID, tbname, colname, coltxt, collen, coltype, coloper, colcontent) VALUES('5', 'A主表', 'ZHD0A0005', '数据来源', '50', 'VARCHAR2', ' ', ' ')
select * from dual;

 

转载于:https://www.cnblogs.com/wxxf/p/11165971.html