Answered You can hire a professional tutor to get the answer.

QUESTION

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.

Show more
LEARN MORE EFFECTIVELY AND GET BETTER GRADES!
Ask a Question