Re: Insert multiple rows with a single statement

From: Dieter Noeth <dnoeth_at_gmx.de>
Date: Sat, 11 Aug 2007 10:13:38 +0200
Message-ID: <f9jr2b$mbc$00$1@news.t-online.com>

sybrandb_at_hccnet.nl wrote:

>> I have 200 such rows. Instead of running the insert command 200 times,
>> is there a way of running it once and pass to it all data values?
>> Thanks,
>> Sashi

>
> Did you actually even read my post and try to understand it?
> If so, why do you post this question? Or do you indeed expect Oracle
> should be MySQL should be a different vendor?

No, he's probably just asking if Oracle supports Standard SQL "table value constructors":

insert into onsite_support_costs
(SITE_ID, LB_CODE, ONSITE_SUPPORT_COST)
values

('Site12284','HZ10',1944.96),
('Site14041','JH96',1728.85),
('Site14942','JV98',28208.94),

...;

Obviously it's not supported :-)

Dieter Received on Sat Aug 11 2007 - 03:13:38 CDT