SELECT * FROM test;
INSERT ALL
INTO test VALUES ('005129', 'zwf')
INTO test VALUES ('005128', 'zff')
INTO test VALUES ('005128', 'zff')
INTO test VALUES ('005128', 'zff')
INTO test VALUES ('005128', 'zff')
INTO test VALUES ('005128', 'zff')
INTO test VALUES ('005128', 'zff')
INTO test VALUES ('005128', 'zff')
SELECT 1 FROM dual;
INSERT INTO test
(
SELECT '005129', 'zwf' FROM dual
UNION
SELECT '005128', 'zff' FROM dual
UNION ALL
SELECT '005128', 'zff' FROM dual
UNION ALL
SELECT '005128', 'zff' FROM dual
UNION ALL
SELECT '005128', 'zff' FROM dual
UNION ALL
SELECT '005128', 'zff' FROM dual
UNION ALL
SELECT '005128', 'zff' FROM dual
UNION ALL
SELECT '005128', 'zff' FROM dual
UNION ALL
SELECT '005128', 'zff' FROM dual
);
Oracle 批量插入数据。