一条SQL安插多条数据

一条SQL插入多条数据INSERT INTO NT_RECHARGEDETAIL(RECHARGEBATCHID,CARDNO,ACCOUNTID,AMT) SELECT 10000

一条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