Avoiding TOO_MANY_ROWS errors in PL/SQL

(Bob Watkins) Oracle’s PL/SQL language has two basic mechanisms for getting data from the database: SELECT and cursors. SELECT is designed to return a single row into local variables; cursors give you the ability to select multiple rows (i.e., a “rowset”) and process them one at a time.

Read More - Register for Free Membership