Examine the following PL/SQL block of code: ... DELETE FROM orders WHERE pay_stat = ‘Overdue’; IF SQL%ROWCOUNT > 5 THEN RAISE out_of_bounds; END IF; ... What value is returned after the statement is run and the DELETE statement returned no rows?

Keep practicing — related questions

• Which of the following exceptions is raised in PL/SQL when a select statement returns zero rows?
• PL/SQL raises an exception, in which TWO of the following cases?
• PL/SQL raises an exception, in which TWO of the following cases:
• PL/SQL raises an exception, in which TWO of the following cases:
• Consider the following table called EMPLOYEES: ID FIRSTNAME LASTNAME JOB LEVEL 1 Paul Jones DBA 2 2 George ...
• PL/SQL raises an exception in which of the following scenarios
• INSERT, UPDATE, DELETE commands when used in a PL/SQL block, should contain INTO clause to hold the data re...
• PL/SQL raises an exception, in which TWO of the following cases: