Oracle一个SQL插入多条数据写法
2021-08-11 本文已影响0人
atdoking
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')