oci_field_type()

oci_field_type - Returns field's data type

Syntax

mixed oci_field_type (resource $statement, int $field)

Arguments

• statement - A valid OCI statement identifier.
• field - Can be the field\'s index (1-based) or name.

Description

Returns a field's data type.

Version

PHP 5, PECL OCI8 >= 1.1.0

Return value

Example #1 oci_field_type() example <?php $conn  =  oci_connect ( "scott",  "tiger"); $stmt  =  oci_parse ( $conn,  "SELECT * FROM emp"); oci_execute ( $stmt); echo  "<table border=\"1\">" ; echo  "<tr>" ; echo  "<th>Name</th>" ; echo  "<th>Type</th>" ; echo  "<th>Length</th>" ; echo  "</tr>" ; $ncols  =  oci_num_fields ( $stmt); for ( $i  =  1 ;  $i  <=  $ncols ;  $i ++) {      $column_name   =  oci_field_name ( $stmt,  $i);      $column_type   =  oci_field_type ( $stmt,  $i);      $column_size   =  oci_field_size ( $stmt,  $i);     echo  "<tr>" ;     echo  "<td> $column_name </td>" ;     echo  "<td> $column_type </td>" ;     echo  "<td> $column_size </td>" ;     echo  "</tr>" ; } echo  "</table>\n" ; oci_free_statement ( $stmt); oci_close ( $conn); ?>