This Transact-SQL stored procedure gets summarized or calculated information from a table based on search criteria. Several possibilities include counting records, summing and averaging values.
Parameter Name |
Type |
Description |
p_select_str |
VARCHAR2 |
The field names to be returned. This forms the SELECT clause in the SQL query. |
p_from_str |
VARCHAR2 |
The additional tables with which a join operation is performed. This forms the FROM clause in the SQL query. |
p_search_str |
VARCHAR2 |
The search criteria forming the WHERE clause of the SQL query. |
p_sort_str |
VARCHAR2 |
The sorting criteria forming the ORDER BY clause of the SQL query. |
p_page_number |
INTEGER |
The page within the result set whose data is to be returned. |
p_batch_size |
INTEGER |
The total number of records to be displayed in a page (table grid). |
p_list |
Cursor Output |
A cursor containing the result set of the SQL query. |