Re: Basic INSERT question

Possible, but somewhat quirky:

INSERT INTO tblTest
SELECT 1, 'Test1' FROM DUAL
UNION ALL
SELECT 2, 'Test2' FROM DUAL
UNION ALL
SELECT 3, 'Test3' FROM DUAL
/

On Thu, 28 Mar 2002 12:51:11 -0000, "Chris A" <candrew_at_oxspring.com> wrote:

>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
>
>
>

regards
Marc Blum
mailto:marc_at_marcblum.de
http://www.marcblum.de Received on Thu Mar 28 2002 - 07:00:09 CST