[Solved] How can you declare and assign a variable counter that increments by 1 inside a loop in PL/pgSQL? — Ans: DECLARE counter integer := 0; BEGIN FOR i IN 1..5 LOOP counter := counter + 1;... | PostgreSQL

PostgreSQL - PL/pgSQL Fundamentals

How can you declare and assign a variable counter that increments by 1 inside a loop in PL/pgSQL?

ADECLARE counter integer := 0; BEGIN FOR i IN 1..5 LOOP SET counter = counter + 1; END LOOP; END;

BDECLARE counter integer; BEGIN FOR i IN 1..5 LOOP counter = counter + 1; END LOOP; END;

CDECLARE counter integer := 0; BEGIN FOR i IN 1..5 LOOP counter += 1; END LOOP; END;

DDECLARE counter integer := 0; BEGIN FOR i IN 1..5 LOOP counter := counter + 1; END LOOP; END;

Step-by-Step Solution

Solution:

Step 1: Check variable initialization
counter must be initialized to 0 before loop.
Step 2: Verify increment syntax inside loop
DECLARE counter integer := 0; BEGIN FOR i IN 1..5 LOOP counter := counter + 1; END LOOP; END; uses ':=' correctly to increment counter inside loop.
Final Answer:
Correctly declares and increments counter -> Option D
Quick Check:
Correct loop increment syntax = A [OK]

Quick Trick: Use ':=' and initialize before loop for increments [OK]

Common Mistakes:

Master "PL/pgSQL Fundamentals" in PostgreSQL

9 interactive learning modes - each teaches the same concept differently

How can you declare and assign a variable counter that increments by 1 inside a loop in PL/pgSQL?