is nvl is required before concatenation to check for null ness.
947771Apr 26 2013 — edited Apr 26 2013hi,
i noticed when any variable or constant is concatenated with other constant or variable it does not get converted into NULL.
is it correct in all cases or should i use NVL(V_xyz,' ') to concatenate as shown in 2) example.
1)
open cv_a for
select 'sdf' || v_xyz from dual;
2)
open cv_a for
select 'sdf' || nvl(v_xyz,' ') from dual;
yours sincerely