Basic INSERT question

Hi,

Why can't I do this in Oracle8:

INSERT INTO tblTest VALUES
(1,'Test 1'),
(2,'Test 2'),
(3,'Test 3');

Is there an alternative syntax I can use that will insert 3 rows in ONE statement ?

Thanks,
Chris Received on Thu Mar 28 2002 - 06:51:11 CST