The number of initial rows to discard when fetching the
result. The default value is 0, so the first row onwards is
returned.

maxrows

The number of rows to return. The default is -1 meaning return
all the rows from skip + 1 onwards.

flags

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 either by column heading or numerically.
Only one index mode will be returned.

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.

Valor Retornado

Returns the number of rows in output, which
may be 0 or more, ou FALSE em caso de falha.

Notas

Nota:

Using skip is very inefficient. All the
rows to be skipped are included in the result set that is
returned from the database to PHP. They are then discarded. It
is more efficient to use SQL to restrict the offset and range of
rows in the query. See oci_fetch_array() for
an example.

Nota:

Queries that return a large number of rows can be more memory
efficient if a single-row fetching function
like oci_fetch_array() is used.