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_where_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_list

Cursor

Output

A cursor containing the result set of the SQL query.