<?php

$conn = OCILogon("scott", "tiger");

$stmt = OCIParse($conn, "select * from emp");

OCIExecute($stmt);

echo "<table border=\"1\">";

echo "<tr>";

echo "<th>Name</th>";

echo "<th>Type</th>";

echo "<th>Length</th>";

echo "</tr>";

$ncols = OCINumCols($stmt);

for ($i = 1; $i <= $ncols; $i++){

$column_name = OCIColumnName($stmt, $i);

$column_type = OCIColumnType($stmt, $i);

$column_size = OCIColumnSize($stmt, $i);

echo "<tr>";

echo "<td>$column_name</td>";

echo "<td>$column_type</td>";

echo "<td>$column_size</td>";

echo "</tr>";

}

echo "</table>";

OCIFreeStatement($stmt);

OCILogoff($conn);

?>