NVL: The NVL function allows you to replace null values with a default value. Simple explanation: if( first parameter's value==null ) then return second parameter value if( first parameter's value!=null) then return first parameter as is Example: nvl("xyz","")---->return xyz nvl(null,'xyz') ------------>return xyz