Differences

This shows you the differences between two versions of the page.

@@ Line 1: / Line 1: @@
+<code>
+<?php
+$emp_name = array('Fay','Taylor', 'yyyyyy', 'xxxxxxx','King' );
+$db = oci_connect('hr','hr','orcl');
+$sql = "select first_name, last_name
+  from employees where last_name = :last_name";
+$q = oci_parse($db,$sql);
+for($i = 0; $i < 100000; $i++) {
+  $r = rand(0,count($emp_name)-1);
+  $last_name = $emp_name[$r].$i;
+  print "i= $i rand = $r last_name = $last_name\n";
+  oci_bind_by_name($q, ":last_name", $last_name, SQLT_CHR );
+  $r = oci_execute($q, OCI_DEFAULT);
+   while ($row = oci_fetch_array($q,OCI_ASSOC+OCI_RETURN_NULLS)) {
+      print_r($row);
+   }
+}
+?>
+</code>

dokuwiki