<?php
define('SYSTEM_DBUSER','USERNAME');
define('SYSTEM_DBPWD','PASSWORD');
define('SYSTEM_DBNAME','DB_OR_SCHEMA');
$db_conn=oci_connect(SYSTEM_DBUSER,SYSTEM_DBPWD,SYSTEM_DBNAME) or die ("DB could not be connected");


$orasql="select * from MYTABE";
$parser = oci_parse($db_conn, $orasql);
oci_execute($parser, OCI_DEFAULT);
$error = oci_error($parser);
$nrows = oci_fetch_all($parser, $rs, 0, $maxrows);
$ncols = oci_num_fields($parser);

//Generate Table
echo "<table border=1 cellpadding=0 cellspacing=0 width=50%>";
echo "<tr><td colspan=".$ncols."</td></tr>";

echo "<tr>";
for ($c=1; $c<=$ncols;$c++) {
$col_name=oci_field_name($parser,$c);
echo "<th>". $col_name ."</th>";
}
echo "</tr>";


for($i=0;$i<$nrows;$i++)
{
echo "<tr>";
for ($c=1;$c<=$ncols;$c++)
{
$col_name=oci_field_name($parser,$c);
$val=$rs[$col_name][$i];
echo "<td align=left>". $val ."</td>";
}
echo "</tr>";
}
echo "</table>";
?>