Re: Insert multiple rows with a single statement

On Sat, 11 Aug 2007 10:13:38 +0200, Dieter Noeth <dnoeth_at_gmx.de> wrote:

>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

There is no such thing as 'SQL standard'. There is a SQL standard with various levels of conformance.
There is no reason to believe the SQL in the toy product MySQL is 'THE' Standard. It is not. MySQL will *never* get the marketshare of Oracle, as Oracle is lightyears ahead.
The only thing which hampers Oracle is stupid developers who believe Oracle is MySQL or Sqlserver sold by a different vendor.

-- 
Sybrand Bakker