is it possible to insert multiple records into oracle 8i through one SQL statement?
i have tried:
insert into table values ('1','2','3'),('2','3','4')
without success.
M
Printable View
is it possible to insert multiple records into oracle 8i through one SQL statement?
i have tried:
insert into table values ('1','2','3'),('2','3','4')
without success.
M
It is a clumsy and ugly sollution, but you can do it lik this:
INSERT INTO TABLE tab1 (c1, c2, c3)
SELECT '1', '2', '3' FROM dual
UNION ALL
SELECT '2', '3', '4' FROM dual;