Answer Detail: RE: explaint the nvl2 function

GeekInterview.com > Interview Questions > Oracle > General

Print |

Question: explaint the nvl2 function

June 06, 2008 09:54:47	#6
thumunagamani	Member Since: June 2008 Total Comments: 1
RE: explaint the nvl2 function
nvl2(exp1,exp2,exp3) if exp1 is null it manipulate exp3,if exp1 is not null it manipulates exp2 eg:select ename,nvl2(comm,comm+sal,sal) net from emp;