PHP 5, PHP 7, PHP 8, PECL OCI8 >= 1.1.0
oci_num_rows - Returns number of rows affected during statement execution
Code Examples

oci_num_rows( resource$statement ): int|false

Gets the number of rows affected during statement execution.



A valid OCI statement identifier.

Return Values

Returns the number of rows affected as an integer, or false on failure



This function does not return number of rows selected! For SELECT statements this function will return the number of rows, that were fetched to the buffer with oci_fetch* functions.


In PHP versions before 5.0.0 you must use ocirowcount instead. This name still can be used, it was left as alias of oci_num_rows for downwards compatability. This, however, is deprecated and not recommended.

Example of oci_num_rows

Show all examples for oci_num_rows

PHP Version:

Function oci_num_rows:

Oracle OCI8 Functions

Most used PHP functions