Answer Detail: RE: explaint the nvl2 function

GeekInterview.com > Interview Questions > Oracle > General

Print |

Question: explaint the nvl2 function

July 07, 2006 10:47:23	#1
G Suresh Babu	Member Since: Visitor Total Comments: N/A
RE: explaint the nvl2 function
Sybtax:- - nvl2(expr1,expr2,expr3)In nvl2 if expr1 evaluates to NULL then expr3 is returned and if it evaluates to some value it returns expr2.for e.g select nvl2(commission_pct,'SAL+COMM','SAL') from employees;if commission_pct is having null value then SAL will be displayed else SAL+COMM.