i want to insert all rows by using only one insert statement likeinsert into orderno values(''&date'' , ''&name'' , &partnum , &quantity , ''&remark'')use in sql....Is there any similar type way in oracle 10g?30-JUN-1996 TRUE WHEEL 42 8 PAID30-JUN-1996 BIKE SPEC 54 10 PAID30-MAY-1996 BIKE SPEC 10 2 PAID30-MAY-1996 BIKE SPEC 23 8 PAID17-JAN-1996 BIKE SPEC 76 11 PAID17-JAN-1996 LE SHOPPE 76 5 PAID1-JUN-1996 LE SHOPPE 10 3 PAID1-JUN-1996 AAA BIKE 10 1 PAID1-JUL-1996 AAA BIKE 76 4 PAID1-JUL-1996 AAA BIKE 46 14 PAID11-JUL-1996 JACKS BIKE 76 14 PAID 解决方案 这篇关于如何在Oracle 10g中的表中插入多行的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持! 上岸,阿里云!
06-15 02:00