Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 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;
- If coalesce( expr1, expr2, ... expr_n ) is not null then do something end if;
- IF p_c_courtesies_cd
- || p_c_language_cd
- || v_c_name
- || v_c_firstname
- || v_c_function
- || p_c_phone
- || p_c_mobile p_c_fax
- || v_c_email is not null
- THEN
- -- Do something
- END IF;
Add Comment
Please, Sign In to add comment