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

A copy of this was sent to "Prakash V" <venkatprakash_at_hotmail.com> (if that email address didn't require changing) On Tue, 07 Sep 1999 17:55:41 GMT, you 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?
>

You cannot. the Wire diagram for 8.1.5 has the arrow in the wrong place for the insert implying that you could repeat the values clause -- it should show that you can report the expression in a values clause so that:

  values (1, 2, 3)

is valid but:

  values (1), value(2), values(3)

is not. the doc for the insert has this wrong -- it indicates the 2cnd method above is correct not the first.

>V Prakash
>
>______________________________________________________
>Get Your Private, Free Email at http://www.hotmail.com
>
>
> Sent via Deja.com http://www.deja.com/
> Share what you know. Learn what you don't.

--
See http://govt.us.oracle.com/~tkyte/ for my columns 'Digging-in to Oracle8i'... Current article is "Part I of V, Autonomous Transactions" updated June 21'st  

Thomas Kyte                   tkyte_at_us.oracle.com
Oracle Service Industries     Reston, VA   USA

Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Tue Sep 07 1999 - 14:40:04 CDT