PHP/HTML返回Oracle数据库查询中的所有行

$conn = oci_connect('username', 'password', 'hostname:port/database');
if (!$conn) {
    $e = oci_error();
    trigger_error(htmlentities($e['message'], ENT_QUOTES), E_USER_ERROR);
}

$query = 'SELECT * FROM your_table';
$statement = oci_parse($conn, $query);
oci_execute($statement);

$result = array();
while ($row = oci_fetch_array($statement, OCI_ASSOC+OCI_RETURN_NULLS)) {
    $result[] = $row;
}

echo '<table>';
foreach ($result as $row) {
    echo '<tr>';
    foreach ($row as $column) {
        echo '<td>' . $column . '</td>';
    }
    echo '</tr>';
}
echo '</table>';