Solution:Step 1: Understand FETCH ALLFETCH ALL returns all remaining rows from the cursor in one go.Step 2: Apply to given codeSince cursor is opened, FETCH ALL retrieves all rows from employees table.Final Answer:Retrieve all rows from the cursor at once -> Option BQuick Check:FETCH ALL = fetch all

[Solved] Consider this code:DECLARE cur CURSOR FOR SELECT name FROM employees; OPEN cur; FETCH ALL FROM cur;What will the FETCH ALL command do? | PostgreSQL

PostgreSQL - Advanced PL/pgSQL

Consider this code:

DECLARE cur CURSOR FOR SELECT name FROM employees;
OPEN cur;
FETCH ALL FROM cur;

What will the FETCH ALL command do?

ARetrieve only the first row

BRetrieve all rows from the cursor at once

CRetrieve no rows until FETCH NEXT is called

DCause a syntax error

Step-by-Step Solution

Solution:

Step 1: Understand FETCH ALL
FETCH ALL returns all remaining rows from the cursor in one go.
Step 2: Apply to given code
Since cursor is opened, FETCH ALL retrieves all rows from employees table.
Final Answer:
Retrieve all rows from the cursor at once -> Option B
Quick Check:
FETCH ALL = fetch all remaining rows [OK]

Quick Trick: FETCH ALL gets all rows remaining in cursor [OK]

Common Mistakes:

Thinking FETCH ALL fetches one row
Assuming FETCH ALL causes error
Confusing FETCH ALL with FETCH NEXT

Master "Advanced PL/pgSQL" in PostgreSQL

9 interactive learning modes - each teaches the same concept differently

Learn Why Deep Visual Try Challenge Project Recall Time

Consider this code:

Step 1: Understand FETCH ALL

Step 2: Apply to given code

Final Answer:

Quick Check:

Want More Practice?