Re: Insert multiple rows with a single statement

From: Dieter Noeth <dnoeth_at_gmx.de>
Date: Sat, 11 Aug 2007 11:28:45 +0200
Message-ID: <f9jvg2$jlh$03$1@news.t-online.com>

sybrandb_at_hccnet.nl wrote:

>> 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.

OK, let's call it
SQL:2003 optional feature F641 "Row and table constructors"

E.g. DB2 supports it, too.

> There is no reason to believe the SQL in the toy product MySQL is > 'THE' Standard.

Neither Oracle SQL.

And even Oracle moves closer to Standard SQL, e.g. JOIN syntax and CASE, maybe even VARCHAR will be implemented the right way in Oracle 12 :-)

Dieter Received on Sat Aug 11 2007 - 04:28:45 CDT