hi all,
SELECT SAL1 ,SAL FROM EMP E WHERE E.NAME='RAJ';
but i dont have record in my table if i have null data using nvl i will use, i want to display o/p like
sal1 sal
--- ----
0 0
SELECT nvl(SAL1,0) ,nvl(SAL,0) FROM EMP E WHERE E.NAME='RAJ'; but this is also not working