European Experts Exchange (EEE.org) :: Free Experts PHP MySql Oracle Microsoft Web SQL Delphi


Databases :: Oracle :: How to insert multiple rows in one INSERT statement in Oracle ?
By: VGR	Date: 10/04/2008 10:05:39	Points: 0	Status: Answered Quality : Excellent
Easy. You can't ;-) (at least with a 9.2.0 version) SQL> insert into stat_prod values (1,100861,10,1102.55,'Vente','10/01/2000'),(1,1,1,NULL,'',NULL),(1 ,102130,5,500,NULL,'20/01/2000'); insert into stat_prod values (1,100861,10,1102.55,'Vente','10/01/2000'),(1,1,1,NULL,'',NULL),(1,1021 * ERREUR à la ligne 1 : ORA-00933: La commande SQL ne se termine pas correctement Oracle can't insert more than 1 row at a time... So Oracle 9.2.0 (2002 or 2004?) doesn't support this SQL99 feature : F641, "Row and table constructors" (outside Core SQL-99) and is limited to Core level. MySql supports it since the beginning, probably even in 3.23.* releases (Aug 1999).
Do register to be able to answer

page generated in 61.525110 milliseconds