Re: Q: Inserting multiple rows with one INSERT??

From: <michael_bialik_at_my-deja.com>
Date: Tue, 07 Sep 1999 21:12:41 GMT
Message-ID: <7r3v3u$5dl$1@nnrp1.deja.com>

In article <19990907175541.74076.qmail_at_hotmail.com>, "Prakash V" <venkatprakash_at_hotmail.com> wrote:
> Could you please tell me in which 8i documentation it is written that
you
> can insert multiple inserts? Because I am surprised that, as for as
my
> knowledge, we cannot insert like that.
>
> Anyone can tell us?
>
> V Prakash

Hi.

It's either using INSERT... SELECT ( it exists even in Oracle7 ) or using PL/SQL BULK BINDs. Look in PL/SQL manual for an examples.

Michael.

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Tue Sep 07 1999 - 16:12:41 CDT