Question

Explain 'FOR............ENDLOOP' statement with example in PL\SQL.

Answer 1

Answer:

This basic LOOP statement consists of a LOOP keyword, a body of executable code, and the END LOOP keywords. The LOOP statement executes the statements in its body and returns control to the top of the loop. Typically, the body of the loop contains at least one EXIT or EXIT WHEN statement for terminating the loop.