当前位置: 代码迷 >> SQL >> 一条SQL安插多条数据
  详细解决方案

一条SQL安插多条数据

热度:110   发布时间:2016-05-05 14:49:00.0
一条SQL插入多条数据
INSERT INTO NT_RECHARGEDETAIL(RECHARGEBATCHID,CARDNO,ACCOUNTID,AMT) SELECT 100000000035,'888123422330000001',1,111.0 FROM DUAL UNION SELECT 100000000035,'100000723010001797',1,111.0 FROM DUAL  UNION SELECT 100000000035,'100000723010001798',1,111.0 FROM DUAL  UNION SELECT 100000000035,'100000723010001799',1,111.0 FROM DUAL  UNION SELECT 100000000035,'100000723010001800',1,111.0 FROM DUAL  UNION SELECT 100000000035,'100000723010001801',1,111.0 FROM DUAL  UNION SELECT 100000000035,'100000723010001802',1,111.0 FROM DUAL  UNION SELECT 100000000035,'100000723010001803',1,111.0 FROM DUAL  UNION SELECT 100000000035,'100000723010001804',1,111.0 FROM DUAL  UNION SELECT 100000000035,'100000723010001805',1,111.0 FROM DUAL  UNION SELECT 100000000035,'100000723010001806',1,111.0 FROM DUAL  UNION SELECT 100000000035,'100000723010001807',1,111.0 FROM DUAL  UNION SELECT 100000000035,'100000723010001808',1,111.0 FROM DUAL  UNION SELECT 100000000035,'100000723010001809',1,111.0 FROM DUAL  UNION SELECT 100000000035,'100000723010001810',1,111.0 FROM DUAL  UNION SELECT 100000000035,'100000723010001811',1,111.0 FROM DUAL  UNION SELECT 100000000035,'100000723010001812',1,111.0 FROM DUAL  UNION SELECT 100000000035,'100000723010001813',1,111.0 FROM DUAL
  相关解决方案