Why does Oracle still not support Multi-Row insert? According to Wikipedia's article about INSERT in SQL, multi-row inserts are standard since SQL-92. Oracle (up to 11g at least) does not support this.
Why?

-- Valid
insert into some_table (magic) values (42);

-- Invalid
insert into some_table (magic) values (42), (666);
-- --&gt; SQL Error: ORA-00933: SQL command not properly ended
The plain answer is that not all RDBMSes support all of the various ANSI standards. Oracle just happens to not support this particular part of it.

Oracle does however support INSERT ALL INTO.

By the way, an example of insert into dual is terribad - You can break older versions of Oracle by doing an INSERT into DUAL.