NVL question

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;

Actually, I would use:

v_keypart1indic := DECODE ( :new.keypart1_use, NULL, 0, 1);

Actually, however, if you look at my suggestions to your original post, you will see that you should really fill these in the EXCEPTION block:

...
v_keypart1indic := 1;
...
EXCEPTION
---WHEN NO_DATA_FOUND THEN
------v_keypart1indic := 0;
...


HTH,

- Chris

Quote:

---

Originally posted by chrisrlong
Actually, I would use:

v_keypart1indic := DECODE ( :new.keypart1_use, NULL, 0, 1);

---

Unfortunatelly the DECODE is not supported in PL/SQL.... ;)

The compiler complaint that DECODE' may be used inside a SQL statement only.