Which statement is true about the outcome?

You execute the following block of code:

Which statement is true about the outcome?

You execute the following block of code:

Which statement is true about the outcome?

A.
Both Output statements show different values.

B.
Both output statements show exactly the same values.

C.
It gives an error because the nested blocks are not labeled.

D.
It gives an error because the V_CUSTOMER variable have different types in the nested blocks



Leave a Reply 14

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


irfan

irfan

A

declare
v_cust varchar2(20) := ‘abc’;
begin
declare
v_cust number(3) := 123;
begin
dbms_output.put_line(v_cust);
end;
dbms_output.put_line(v_cust);
end;

Jen

Jen

declare
v_cust varchar2(20) := ‘abc’;
begin
declare
v_cust number(3) := 123;
begin
dbms_output.put_line(v_cust);
end;
dbms_output.put_line(v_cust);
end;

===========================================
PL/SQL procedure successfully completed.
123
abc

Andreea

Andreea

A is the correct answer.I tested it.