You want to write a PostgreSQL FOR loop that iterates over all rows in a table employees and prints each employee's name. Which code snippet correctly does this?
hard📝 Application Q8 of 15
PostgreSQL - PL/pgSQL Fundamentals
You want to write a PostgreSQL FOR loop that iterates over all rows in a table employees and prints each employee's name. Which code snippet correctly does this?
ALOOP
SELECT name FROM employees;
RAISE NOTICE '%', name;
END LOOP;
BFOR emp_record IN SELECT name FROM employees LOOP
RAISE NOTICE '%', emp_record.name;
END LOOP;
CWHILE emp_record IN employees LOOP
RAISE NOTICE '%', emp_record.name;
END LOOP;
DFOR emp_record IN 1..(SELECT COUNT(*) FROM employees) LOOP
RAISE NOTICE '%', emp_record.name;
END LOOP;
Step-by-Step Solution
Solution:
Step 1: Understand how to loop over query results
PostgreSQL FOR loops can iterate over query results using FOR var IN SELECT ... LOOP.
Step 2: Check each option for correct syntax and logic
FOR emp_record IN SELECT name FROM employees LOOP
RAISE NOTICE '%', emp_record.name;
END LOOP; correctly uses a FOR loop over a SELECT query and accesses emp_record.name.
Final Answer:
FOR emp_record IN SELECT name FROM employees LOOP
RAISE NOTICE '%', emp_record.name;
END LOOP; -> Option B
Quick Check:
FOR loop over SELECT query = FOR emp_record IN SELECT name FROM employees LOOP
RAISE NOTICE '%', emp_record.name;
END LOOP; [OK]
Quick Trick:Use FOR ... IN SELECT ... LOOP to iterate rows [OK]
Common Mistakes:
Using numeric ranges instead of query results
Misusing WHILE for row iteration
Trying to SELECT inside LOOP without INTO
Master "PL/pgSQL Fundamentals" in PostgreSQL
9 interactive learning modes - each teaches the same concept differently
