Declare
v_ex number;
v_ey number;
Begin
v_ex:=NULL;
v_ey:=NULL;
IF v_ey=v_ex then
Statement1...
End;
Statement2...
End;
In the given code, the v_ex and v_ey variables are assigned a NULL value. When the two NULL values are compared, they give a NULL value. As a result, the IF condition in the code does not execute or give any output.
v_ex number;
v_ey number;
Begin
v_ex:=NULL;
v_ey:=NULL;
IF v_ey=v_ex then
Statement1...
End;
Statement2...
End;
In the given code, the v_ex and v_ey variables are assigned a NULL value. When the two NULL values are compared, they give a NULL value. As a result, the IF condition in the code does not execute or give any output.