General - explaint the nvl2 function

GeekInterview.com > Interview Questions > Oracle > General

Go To First | Previous Question | Next Question

General | Question 201 of 210

explaint the nvl2 function

Total Answers and Comments: 7

Last Update: June 16, 2008 Asked by: senthil

Sponsored Links

Best Rated Answer

—

No best answer available. Please pick the good answer available or submit your answer.

July 26, 2006 10:47:23

G Suresh Babu

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.

Is this answer useful? Yes | No

August 15, 2006 09:45:56

gouthami

RE: explaint the nvl2 function

SYNTAX FOR NVL2(EXPR1,EXPR2,EXPR3);

NVL2

Is this answer useful? Yes | No

October 03, 2006 10:27:43

sundar

RE: explaint the nvl2 function

nvl2-- can take three arguments

by using this we can convert null to values

nvl(a,b,c)

if a is null it will display c

if a is not null it ll display b

Is this answer useful? Yes | No

October 05, 2006 06:07:40

PAWANAHUJAHUJA

Member Since: October 2006 Contribution: 6

RE: explaint the nvl2 function

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

Is this answer useful? Yes | No

December 20, 2006 12:55:52

sangeetha

RE: explaint the nvl2 function

Eg;NVL(comm,null),it takes null value as zero

Is this answer useful? Yes | No

June 13, 2008 09:54:47

thumunagamani

Member Since: June 2008 Contribution: 1

RE: explaint the nvl2 function

nvl2(exp1,exp2,exp3)
if exp1 is null it manipulate exp3,if exp1 is not null it manipulates exp2
eg:select ename,nvl2(comm,comm+sal,sal) net from emp;

Is this answer useful? Yes | No

June 16, 2008 03:48:16

nandk.sharma

Member Since: June 2008 Contribution: 10

RE: explaint the nvl2 function

nvl2 function is the upgraded form of nvl function.In nvl function we need to pass two parameters.i.e. nvl(interest_rate ,returned_value) if the value of interest_rate is null then the nvl function returns the value of second parameter 'returned_value'.In nvl2 function we need to pass three parameters .i.e. nvl2 (interest_rate,returned_value_if_not_null,returned_value_if_null)if the value of interest_rate is null then the nvl function returns the value of the third parameter 'returned_value_if_null' else it returns the value of the second parameter 'returned_value_if_not_null'.

Is this answer useful? Yes | No

Go To Top