Which of the following is the correct syntax for an EXECUTE IMMEDIATE statement?
A) EXECUTE IMMEDIATE 'SQL statement'
[ INTO ( var1, var2, ... | record ]
[ USING [ IN | OUT | IN OUT ] bindvar1, bindvar2, ... ]
[ RETURNING | RETURN INTO outvar1, outvar2, ... ];
B) EXECUTE IMMEDIATE 'SQL statement'
[ INTO ( var1, var2, ... | record ]
[ RETURNING | RETURN INTO outvar1, outvar2, ... ]
C) EXECUTE IMMEDIATE 'SQL statement'
[ INTO ( var1, var2, ... | record ]
[ USING [ IN | OUT | IN OUT ] bindvar1, bindvar2, ... ]
D) EXECUTE IMMEDIATE 'SQL statement'
[ USING [ IN | OUT | IN OUT ] bindvar1, bindvar2, ... ]
[ RETURNING | RETURN INTO outvar1, outvar2, ... ];

Question

Quizplus · Accepted Answer

The correct syntax for an EXECUTE IMMEDIATE statement includes the SQL statement to be executed, an optional INTO clause for retrieving data into variables or a record, and an optional USING clause for passing in bind variables. It can also include a RETURNING or RETURN INTO clause for retrieving values from the executed statement. Choice A includes all of these options, making it the correct syntax.

Which of the Following Is the Correct Syntax for an EXECUTE