1. API Reference
  2. APEX_EXEC
  3. GET_TOTAL_ROW_COUNT Function

GET_TOTAL_ROW_COUNT Function

This function returns the total row count of the query result.

Syntax

function get_total_row_count (
    p_context in t_context ) return pls_integer;

Parameters

Table 14-14 GET_TOTAL_ROW_COUNT Function Parameters

Parameter Description

p_context

Context object obtained with one of the OPEN_ functions.

Returns

The total row count; NULL if unknown.

Parent topic: APEX_EXEC