NVL2 Function

The NVL2(X,value1,value2) function returns value1, if x is not null; otherwise, it return value2

i.e. Select (mname , nvl2(mname, ‘specified’, ’not specified’) from manager;

Mname                                     nvl2(mname, ‘specified’, ’not specified’)

--------------------                            ------------------------------------------------------

AJAY                                        specified

VIJAY                                       specified

                                                not specified

JAYA                                        specified