1Z0-149: Oracle Database Program with PL/SQLDemo

By Oracle · Question Mode

QuestionQ56

PL/SQL Language Fundamentals

Which statement is true about counter variables in a FOR loop?

  • A It must explicitly be declared.
  • B It can be modified in the body of the loop.
  • C It cannot be NULL.
  • D It is accessible outside the body of the loop.
Explanation

In a PL/SQL numeric FOR loop, the counter is assigned an integer value for each iteration and therefore cannot be NULL during an iteration. The counter is implicitly declared, read-only within the loop body, and local to that loop.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!