ocicolumntype

Description

ocicolumntype() returns the data type of the column corresponding to the column number (1-based) that is passed in.

Example 1. ocicolumntype() example <?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>\n";    OCIFreeStatement($stmt);     OCILogoff($conn);  ?>