Examine the following partial declare section from a block of PL/SQL code
Which line(s) in the above code are NOT valid? (Choose all that apply.)
A.
line 2
B.
line 3
C.
line 4
D.
line 5
Which line(s) in the above code are NOT valid?
Examine the following partial declare section from a block of PL/SQL code
(Exhibit)
Which line(s) in the above code are NOT valid? (Choose all that apply.)
B and D are correct
B and D are correct.
B) Variable declared as NOT NULL must have initial value. It should be something like: v_total_wages v_wage%type := 500;
D) work_complete is CONSTANT
completely Agree with you mr P0
To explain why D (Line 5) is wrong the %TYPE attribute can NOT be used with a constant.
See LINK: http://docs.oracle.com/cd/E11882_01/appdev.112/e25519/type_attribute.htm#LNPLS01352
La respuesta correcta es la B y la D.
No se puede usar %TYPE con variables que fuero creadas como constantes o declaradas con el constaint NOT NULL.
correct answers are B and D.
We do not use %type with a constant.
B and D is the correct answer.
error would be v_wage must be a type and work_complete must be a type.
B,D
B D
B and D are correct
%TYPE inherits constraints without values from attributes of PL/SQL
B and D are correct, the testing point is that %TYPE inherit the constraint of referening data type, thus B must have one initialized value to fit NOT NULL, and D must have one constant value.