欢迎您访问程序员文章站本站旨在为大家提供分享程序员计算机编程知识!
您现在的位置是: 首页

一条SQL插入多条数据

程序员文章站 2022-03-21 14:23:31
...
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
相关标签: SQL

上一篇: 常用函数

下一篇: EL自定义函数