Oracle inequality

Posted on 2010-06-08 19:24:07

While converting a bit of Oracle PL/SQL to Java today, I found this nugget:

if to_number(nvl(r_status.some_field,0)) < 2 or
   to_number(nvl(r_status.some_field,0)) > 2
then
  -- do something
end if;

Obviously the coder who wrote this has never heard of the ‘<>’ and ‘!=’ operators…

Posted in: Computers, Work