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

a. True
b. False

ANSWER: True
 
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.

Post your comment / Share knowledge


Enter the code shown above:
 
(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)