@ammoQ said:
syntax of the INSERT statementWell, this actually applies
to all SQL databases, not just Oracle... but since they already
introduced so many proprietary SQL extensions, they could have cared
for that one too:INSERT INTO mytable (c1, c2, c3, ..., c57) VALUES (v1, v2, v3, ..., v57)What'swrong with it? Try to match the entries in the column list with the
entries in the value list. Nearly impossible for tables with many
columns. I would gladly welcome a DBMS which introduces a new
(UPDATE-like) syntax:INSERT INTO mytable SET c1=v1, c2=v2, c3=v3, ..., c57=v57If you know such a DBMS, please tell me.
MySQL handles that just fine