Single Row Function - NULL Related Function

NULL has special meaning , we can't compare null with other null value.
Can't use NULL value in any calculation,but sometimes we need null valued column in our calculation.

For this we have some special function that change null value with some other value.

1. NVL Function
2. NVL2 Function
3. COALESCE Function
4. NULLIF Function
5. LNNVL Function
6. NANVL Function

1. Oracle SQL/PLSQL : NVL Function

Syntax :  NVL(column|expr|null,default_value)

Purpose:    
 NVL Function  is used to replace null with some default value.
Example: