Q: Inserting multiple rows with one INSERT??

From: Thilo Frotscher <thilo.frotscher_at_igd.fhg.de>
Date: Tue, 07 Sep 1999 17:51:09 +0200
Message-ID: <37D5346D.95B2AD1@igd.fhg.de>

Hello everyone,
the html documentation of Oracle 8i contains a syntax definition for the

INSERT statement. There it is shown, that a single INSERT statement can have multiple VALUES-clauses, separated by commas. Thus, it should be possible to insert multiple rows into a table using only one INSERT statement, shouldn't it??

I tried this, following the syntax definition, but it didn't work:

INSERT INTO test VALUES ('aaa', 'bbb'), VALUES ('ccc', 'ddd');

produces an error message. Why?

Thanks for your help,
Thilo Frotscher

--

---

                 Thilo Frotscher

  EDV-Beratung, Software-Entwicklung, Schulung

 Java - Internet - Datenbanken - Windows - Unix

---

I have no idea what people will be fighting with, if there is a World War III someday. But if there is a World War IV as well, stones and clubs will be their weapons, that's for sure. (A.Einstein)

---

Received on Tue Sep 07 1999 - 10:51:09 CDT