QUOTE (HAL9000 @ Mar 28 2012, 12:59 PM)
"2 nvl2('',doj,'new joinee')"RESULT" from samp;"
This is nonsense, you have no clew.
You are obviously not prepared to start learning Oracle.
It appears as if you have no skills in computer science whatsoever.
NVL ( expr1 , expr2 ): If expr1 is null, then NVL returns expr2. If expr1 is not null, then NVL returns expr1.
NVL2 ( expr1 , expr2 , expr3 ): If expr1 is null, then NVL2 returns expr3. If expr1 is not null, then NVL2 returns expr2http://www.dba-oracle.com/t_nvl_vs_nvl2.htm
It is possible to display :
I didn't get from you clearly. i am not asking about nvl and nvl2 function characteristics.
need to dispaly emp in specific field using nvl2 function.
Try this query
SQL> select name, nvl2(empid,empid,'new_joinee') from samp;
this is what i really expect.