Retrieve each row of result into %ROWTYPE record & process each row in loop - SQL Operations
Q. With PL/SQL, it is very simple to issue a query, retrieve each row of the result into a %ROWTYPE record, and process each row in a loop.- Published on 07 Jul 15
The %ROWTYPE record processes each row in a loop:
1. It includes the text of the query directly in the for loop
2. It creates a record with fields corresponding to the columns.
3. The fields of the records are inside the loop. The test, calculations, display outputs are stored in other place.