INSERT ALL
INTO TABLE_NAME(ACTNO, CUSTNO)VALUES('TEST1', 'CUS1')
INTO TABLE_NAME(ACTNO, CUSTNO)VALUES('TEST2', 'CUS2')
INTO TABLE_NAME(ACTNO, CUSTNO)VALUES('TEST2', 'CUS2')
INSERT ALL
INTO TABLE_NAME(ACTNO, CUSTNO)VALUES('TEST1', 'CUS1')
INTO TABLE_NAME(ACTNO, CUSTNO)VALUES('TEST2', 'CUS2')
INTO TABLE_NAME(ACTNO, CUSTNO)VALUES('TEST2', 'CUS2')
本文标题:Oracle一个SQL插入多条数据写法
本文链接:https://www.haomeiwen.com/subject/rurkbltx.html
网友评论