Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

nvl function

1043556Jun 22 2015 — edited Jun 22 2015

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

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 20 2015
Added on Jun 22 2015
7 comments
208 views