使用的是ADODB库,需要有OCI8库. <?php //require("adodb5/adodb-exceptions.inc.php"); require("adodb5/adodb.inc.php"); $conn = NewADOConnection("oci8"); $conn->Connect($url, $user, $password, $service_name); $rs; try { $rs = $conn->Execute("SELECT * FROM (SELECT rownum r,ima_file.* FROM ima_file) s WHERE s.r >= 9000 AND s.r <= 10000"); } catch(exception $e) { print_r($e); } $i = 0; echo "<table border=1><caption>IMA_FILE</caption><thead><td>计数</td><td>行数</td><td>料件号</td><td>品名</td><td>规格</td></thead>"; foreach($rs as $row) { echo "<tr><td>" . ++$i . "</td><td>$row[0]</td><td>{$row[1]}</td><td>{$row[2]}</td><td>{$row[3]}</td></tr>"; } echo "</table>"; ?>