nvl2 function only , not nvl function, please understand my question Options

[thiyagusham]

SQL> select * from samp;


NAME DOJ QUAL EMPID
---------- --------------- ---------- -----
sam 21-mar-2012 mca
sony 03-jan-2000 mba 10610
maya 21-mar-2012 m.arch
sonna 18-mar-2012 mis

SQL> select name,doj,qual,empid,
2 nvl2('',doj,'new joinee')"RESULT" from samp;

NAME DOJ QUAL EMPID RESULT
---------- --------------- ---------- ----- - -------------
sam 21-mar-2012 mca new joinee
sony 03-jan- 2000 mba 10610 new joinee
maya 21-mar-2012 m.arch new joinee
sonna 18-mar-2012 mis new joinee

i want to display in result column 10610 in second row , because emp sony having id "10610 "
should i use sub-query ? without sub-query how can i display ????
thanks .

[HAL9000]

"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 expr2

http://www.dba-oracle.com/t_nvl_vs_nvl2.htm

[Florin Aparaschi...]

NVL2(empid, empid, 'new joinee')

[thiyagusham]

"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 expr2

http://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;

NAME NVL2(EMPID
--------------- ----------
sam new_joinee
chris 10610
rose new_joinee
sona new_joinee
maya new_joinee

this is what i really expect.

[burleson]

>> This is what i really expect.

I would lower your expectations.

This is a DBA forum, and it is only for asking questions.

Do you have a question?

If you want Oracle support instead, you need to go here:

http://support.oracle.com

Good Luck!