Hi,

Can someone help me to see the following codes which is part of the trigger, I just like to make sure the syntax is correct.

if (nvl(:new.keypart1_use,'nothing') = 'nothing') then
v_keypart1indic := 0;
else
v_keypart1indic := 1;
end if;

if (nvl(:new.keypart2_use,'nothing') = 'nothing') then
v_keypart2indic := 0;
else
v_keypart2indic := 1;
end if;

if (nvl(:new.keypart3_use,'nothing') = 'nothing') then
v_keypart3indic := 0;
else
v_keypart3indic := 1;
end if;