Oracle INSERT
| From: | Chris Andrew | Date: | Thu, 28 Mar 2002 13:14:42 +0000 |
| Subject: | Oracle INSERT | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-17994@lists.php.net to get a copy of this message | ||
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