database - 构建 PL/SQL IF THEN 语句的更好方法？

Question

只是想知道是否有更好的方法在 ORACLE 中编写以下 PL/SQL 代码段？

IF(p_c_courtesies_cd is not null 
OR  p_c_language_cd is not null
OR v_c_name is not null
OR v_c_firstname is not null
OR v_c_function is not null
OR p_c_phone is not null
OR p_c_mobile is not null
OR p_c_fax is not null
OR v_c_email is not null
) THEN
     -- Do something
END IF;

Answer 1

If coalesce( expr1, expr2, ... expr_n ) is not null then do something end if;

See here.

(感谢东尼指正)