Re: Basic INSERT question

From: Stephen B <stephen.bell_at_cgi.ca>
Date: Thu, 28 Mar 2002 09:22:40 -0500
Message-ID: <2JFo8.12594$ra.1836862@news20.bellglobal.com>

Hi Chris,

The INSERT....VALUES syntax is for one row.

As the other poster has indicated there is an INSERT...SELECT syntax that will select multiple rows from existing table(s).

I hope this helps,

Steve

"Chris A" <candrew_at_oxspring.com> wrote in message news:NlEo8.4567$Vm5.34087_at_NewsReader...
> 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 - 08:22:40 CST