php oci_fetch_all,oci_fetch_all

Parameter flags indicates the array

structure and whether associative arrays should be used.

oci_fetch_all() Array Structure Modes Constant Description

OCI_FETCHSTATEMENT_BY_ROW The outer array will contain one sub-array per query

row.

OCI_FETCHSTATEMENT_BY_COLUMN The outer array will contain one sub-array per query

column. This is the default.

Arrays can be indexed by column heading or numerically.

oci_fetch_all() Array Index Modes Constant Description

OCI_NUM Numeric indexes are used for each column's array.

OCI_ASSOC Associative indexes are used for each column's

array. This is the default.

Use the addition operator "+" to choose a combination

of array structure and index modes.

Oracle's default, non-case sensitive column names will have

uppercase array keys. Case-sensitive column names will have

array keys using the exact column case.

Use var_dump()

on output to verify the appropriate case

to use for each query.

Queries that have more than one column with the same name

should use column aliases. Otherwise only one of the columns

will appear in an associative array.