Clever Oracle Solution With NVL() function
There is a NVL(param1, param2) function in oracle which comes in handy when we want to replace the NULL value with another value. Here if the value of param1 is
There is a NVL(param1, param2) function in oracle which comes in handy when we want to replace the NULL value with another value. Here if the value of param1 is null, then it is replaced with the value of param2. \n\n\n```\nSELECT NVL(E.EMPLOYEE_ID, S.EMPLOYEE_ID) AS EMPLOYEE_ID \nFROM EMPLOYEES E\nFULL JOIN SALARIES S ON E.EMPLOYEE_ID = S.EMPLOYEE_ID\nWHERE E.NAME IS NULL\nOR S.SALARY IS NULL \nORDER BY EMPLOYEE_ID;\n```
['Oracle']