Hi everybody,

This is new features in 9i,

NVL means select nvl(comm,0) from tablename;

we r selecting a column comm that contain null values then it will be give by o or any specific name that u want,

in NVL2 means select NVL2(comm,sal+comm,sal) frm tab_name,

if first exp is true it will give sal only otherwise it will give sal+comm.

Regards

Pawan Ahuja