Answered You can hire a professional tutor to get the answer.
Q4. Consider the following SELECT-INTO statement in a PL/SQL block. What happens if there is NO row satisfying the WHERE condition?
Q4. Consider the following SELECT-INTO statement in a PL/SQL block. What happens if there is NO row satisfying the WHERE condition?
......
SELECT COUNT(*)
INTO v_count
FROM tab1
WHERE c15 > 0 OR c20 > 0;
......
A. A NO_DATA_FOUND exception is raised.
B. A TOO_MANY_ROWS exception is raised.
C. A ZERO_DIVIDE exception is raised.
D. The SELECT-INTO statement executes successfully.