0

Didn't understand Meaning of this query

select ename, empno, sal, comm, sal+nvl(comm,0) from emp; Here what is a meaning of '( )' & ' , ' bracket & comma? why we are using () & , signs??

1st Sep 2017, 9:48 AM
Nitin Kotadia
Nitin Kotadia - avatar
2 odpowiedzi
+ 1
nvl(comm,0) means if commission is null or blank then use 0
27th Sep 2017, 12:32 PM
Gurpreet Singh
Gurpreet Singh - avatar
0
Thankyou
28th Oct 2017, 10:11 AM
Nitin Kotadia
Nitin Kotadia - avatar