Multiple choice technology databases

SQLCODE and SQLERRM cannot be used within a SQL statement directly. Instead, you must assign their values to local variables, then use the variables in the SQL statement

  1. True

  2. False
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

In PL/SQL, functions SQLCODE and SQLERRM cannot be referenced directly within SQL DML statements. They must first be assigned to local PL/SQL variables, which can then be safely used inside SQL queries or statements.

Keep practicing — related questions