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 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.