SQL: ".$sql;
echo "\n";
$stmt = OCIParse($con, $sql);
OCIExecute($stmt);
echo "
\n";
for ($i=1; $i<=OCINumCols($stmt); $i++) {
echo "| ";
echo OCIColumnName($stmt,$i);
echo " | \n";
}
echo "
\n";
echo "";
while (OCIFetchInto($stmt, &$result, OCI_ASSOC)) {
echo "";
for ($i =1; $i<=OCINumCols($stmt); $i++) {
echo "| ";
echo $result[OCIColumnName($stmt,$i)];
echo " | ";
}
echo "
\n";
}
echo "
\n";
}
$sql = "SELECT cols.column_name as Name, nullable, data_type as Type, Decode( data_type, 'NUMBER', data_precision + data_scale, data_length ) Length, data_precision Precision, data_scale Scale, data_length length, data_default, ' ' comments FROM user_tab_columns cols WHERE cols.table_name = 'EMP' order by column_id";
DisplayTable($con, $sql);
$sql = "SELECT table_name, tablespace_name, pct_free, pct_used, initial_extent, next_extent, pct_increase, degree, instances, decode(ltrim(cache),'Y', 'CACHE', 'NOCACHE') cache FROM user_tables where table_name='EMP'";
DisplayTable($con, $sql);
$sql = "SELECT A.UNIQUENESS, A.INDEX_NAME, A.TABLES PACE_NAME AS Tablespace, A.INITIAL_EXTENT AS InitialExtentSize, A.PCT_INCREASE AS PercentIncrease, A.PCT_FREE AS MinimumPercentFree, A.next_extent FROM USER_INDEXES A WHERE (A.TABLE_NAME = 'EMP')";
DisplayTable($con, $sql);
$sql = "SELECT comments FROM user_tab_comments WHERE table_name = 'EMP' AND comments IS NOT NULL" ;
DisplayTable($con, $sql);
$sql = "SELECT column_name, comments FROM user_col_comments WHERE table_name = 'EMP' AND column_name = 'EMPNO'";
DisplayTable($con, $sql);
//while (OCIFetchInto($stmt, &$result, OCI_ASSOC)) {
// echo $result['TABLE_NAME'];
// echo "
\n";
//}
// Disconnect from Oracle
OCILogoff($con);
?>
by Hans Schou <chlor@schou.dk>
http://www.schou.dk
Source file: $fn\n";
else
echo "Source file $fn is not available< /i>\n";
?>