What is the difference between NVL and NVL2 functions ?
nvl has only 2 arguments whereas nvl2 has 3 arguments. Both function operates on any datatype pertaining to null values. example nvl (comm,0) will give you comm when not null otherwise it will return 0. nvl2(comm,1,0) will give you 1 when comm is not null and 0 when comm is null.
oracle has nvl2? i know nvl but havent heard of nvl2 before