Which statement is true about the execution of the code?

Examine the following PL/SQL code:

The server output is on for the session. Which statement is true about the execution of the code?

Examine the following PL/SQL code:

The server output is on for the session. Which statement is true about the execution of the code?

A.
It displays null if no employee with empioyee_id 123 exists.

B.
It produces the ora-01403: no data found error if no employee with empioyee_id 123 exists.

C.
It displays an error because the select into clause cannot be used to populate the PL/SQL
record type.

D.
The code executes successfully even if no employee with empioyee_id 123 exists and displays
Record Not Found.

Explanation:



Leave a Reply 6

Your email address will not be published. Required fields are marked *


samkelo siyabonga ngubo

samkelo siyabonga ngubo

B