Multiple choice technology databases

Limitation for level of label Nesting in a PL/SQL program

  1. No limitations

  2. 89

  3. 76

  4. 98
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

Oracle PL/SQL has a maximum nesting level of 98 for labels (block labels). Labels are used to name PL/SQL blocks for GOTO statements and qualified references with the <> syntax. While you can create deeply nested block structures, Oracle imposes this practical limit to prevent excessive complexity and potential performance issues. The 'no limitations' option is incorrect, and the specific numbers 89 and 76 are not the actual Oracle limits.

Keep practicing — related questions