php man page for oci_field_name

Query: oci_field_name

OS: php

Section: 3

Format: Original Unix Latex Style Formatted with HTML and a Horizontal Scroll Bar

OCI_FIELD_NAME(3)														 OCI_FIELD_NAME(3)

oci_field_name - Returns the name of a field from the statement

SYNOPSIS
string oci_field_name (resource $statement, mixed $field)
DESCRIPTION
Returns the name of the $field.
PARAMETERS
o $statement - A valid OCI statement identifier. o $field - Can be the field's index (1-based) or name.
RETURN VALUES
Returns the name as a string, or FALSE on errors.
EXAMPLES
Example #1 oci_field_name(3) example <?php // Create the table with: // CREATE TABLE mytab (number_col NUMBER, varchar2_col varchar2(1), // clob_col CLOB, date_col DATE); $conn = oci_connect("hr", "hrpwd", "localhost/XE"); if (!$conn) { $m = oci_error(); trigger_error(htmlentities($m['message']), E_USER_ERROR); } $stid = oci_parse($conn, "SELECT * FROM mytab"); oci_execute($stid, OCI_DESCRIBE_ONLY); // Use OCI_DESCRIBE_ONLY if not fetching rows echo "<table border="1"> "; echo "<tr>"; echo "<th>Name</th>"; echo "<th>Type</th>"; echo "<th>Length</th>"; echo "</tr> "; $ncols = oci_num_fields($stid); for ($i = 1; $i <= $ncols; $i++) { $column_name = oci_field_name($stid, $i); $column_type = oci_field_type($stid, $i); echo "<tr>"; echo "<td>$column_name</td>"; echo "<td>$column_type</td>"; echo "</tr> "; } echo "</table> "; // Outputs: // Name Type // NUMBER_COL NUMBER // VARCHAR2_COL VARCHAR2 // CLOB_COL CLOB // DATE_COL DATE oci_free_statement($stid); oci_close($conn); ?>
NOTES
Note In PHP versions before 5.0.0 you must use ocicolumnname(3) instead. This name still can be used, it was left as alias of oci_field_name(3) for downwards compatability. This, however, is deprecated and not recommended.
SEE ALSO
oci_num_fields(3), oci_field_type(3), oci_field_size(3). PHP Documentation Group OCI_FIELD_NAME(3)
Related Man Pages
oci_define_by_name(3) - php
oci_field_scale(3) - php
oci_field_size(3) - php
oci_field_type_raw(3) - php
oci_parse(3) - php
Similar Topics in the Unix Linux Community
ls command help
floating point numbers in if
Find error in the shell script file
Peculiar behavior due to IFS
Cat command does not respect new line