(PHP 3 = 3.0.4, PHP 4 )

OCIColumnSize -- Return result column size

Description

int OCIColumnSize ( int stmt, mixed column)

OCIColumnSize() returns the size of the column as given by Oracle. You can either use the column-number (1-Based) or the column-name for the col parameter.

範例 1. OCIColumnSize

 ?php   
    print " HTML  PRE \n";   
    $conn = OCILogon("scott", "tiger");
    $stmt = OCIParse($conn,"select * from emp");
    OCIExecute($stmt);
    print " TABLE BORDER=\"1\" ";
    print " TR ";
    print " TH Name /TH ";
    print " TH Type /TH ";
    print " TH Length /TH ";
    print " /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);
        print " TR ";
        print " TD $column_name /TD ";
        print " TD $column_type /TD ";
        print " TD $column_size /TD ";
        print " /TR ";
    }
    print " /TABLE ";
    OCIFreeStatement($stmt);  
    OCILogoff($conn);   
    print " /PRE ";
    print " /HTML \n"; 
? 


See also OCINumCols(), OCIColumnName(), and OCIColumnSize().