RE: [PHP-DB] Oracle INSERT

I don't know if you can do in one INSERT INTO statements per se in Oracle, try to separate insert into statements with semicolon(;) .. Or if you will insert the data that is already in another table you can use INSERT INTO ... SELECT ... FROM ... syntax. Gurhan -----Original Message----- From: Chris Andrew [mailto:candrew@oxspring.com] Sent: Thursday, March 28, 2002 8:15 AM To: php-db@lists.php.net Subject: [PHP-DB] Oracle INSERT Hi, This is probably more of a topic for the Oracle groups - however: This gives me an error: $c1 = ocilogon("chris","chris01"); $sql = "INSERT INTO tblTest VALUES(1,'Test One'),(2,'Test Two')"; $stat= ociparse($c1,$sql); It would appear my INSERT syntax is illegal under Oracle. Qu: How can I INSERT multiple rows with ONE statement? Thanks in advance. Chris -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php