NULLIF compares expr1 and expr2. If they are equal, then the function returns
null. If they are not equal, then the function returns expr1. You cannot specify the
literal NULL for expr1
if (col1=666) then
return null
else
return col1
end if;
来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/129556/viewspace-609219/
,如需转载,请注明出处,否则将追究法律责任。