很容易犯的一个错误, In Oracle when empty string compare with other not null string, the value is always NULL,
当 STR_1 是空字符串,STR_1 != STR_2 将返回FALSE. STR! 不会被赋值为STR2.
IF STR_1 != STR_2 THEN
STR1:=STR2;
END IF;
正确的改写
IF STR_1 IS NULL AND STR_2 IS NOT NULL OR STR_1 != STR_2 THEN
STR1:=STR2;
END IF;