In PL/pgSQL, how do you correctly execute a dynamic SQL statement stored in the variable dyn_sql and store the result into a variable result_var?

easy📝 Syntax Q3 of 15

PostgreSQL - Advanced PL/pgSQL

In PL/pgSQL, how do you correctly execute a dynamic SQL statement stored in the variable dyn_sql and store the result into a variable result_var?

AEXECUTE result_var INTO dyn_sql;

BEXECUTE INTO result_var dyn_sql;

CEXECUTE 'dyn_sql' INTO result_var;

DEXECUTE dyn_sql INTO result_var;

Step-by-Step Solution

Solution:

Step 1: Understand EXECUTE syntax
The EXECUTE statement runs a dynamic SQL command stored in a variable or string.
Step 2: Correct placement of INTO clause
In PL/pgSQL, the INTO clause must immediately follow EXECUTE and precede the variable to store the result.
Final Answer:
EXECUTE dyn_sql INTO result_var; -> Option D
Quick Check:
EXECUTE runs dynamic SQL; INTO stores output [OK]

Quick Trick: EXECUTE dyn_sql INTO var; stores query result [OK]

Common Mistakes:

Master "Advanced PL/pgSQL" in PostgreSQL

9 interactive learning modes - each teaches the same concept differently

Want More Practice?

15+ quiz questions · All difficulty levels · Free