Examine the following block of code:
Which line in the above code would result in errors upon execution?
A.
line 5
B.
line 8
C.
line 2
D.
line 7
Which line in the above code would result in errors upon execution?
Examine the following block of code:
(Exhibit)
Which line in the above code would result in errors upon execution?
B
it should be D, isn’t it? because done’s variable type is boolean and it’s assigned with number
Erita, it’s B.
D is wrong. (net_value > 100) is TRUE, and TRUE is assigned to done variable.
is boolean supported in SQL??
http://docs.oracle.com/cd/B28359_01/appdev.111/b28370/dynamic.htm#LNPLS011
boolean supported in PL/SQL, not SQL
correct answer is B
It will give error… expression is of wrong type.
B
B is correct , because
in D can use condition in assign variable but can’t in return like in function
in B can’t assign data type with another data type (varchar2 := boolean)
thanks for all