What is the usage of NVL?

Categories >> Software >> Databases >> SQL PLSQL
Suggest New Category

Question Posted / sumitha

7 Answers
18886 Views
Infosys, Micro Infotek, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

What is the usage of NVL?..

Answer / shailesh

When we want to handle the null value of any column then we
use nvl function.

Is This Answer Correct ?

27 Yes

1 No

What is the usage of NVL?..

Answer / surendra

it is used to convert null values to any value

Is This Answer Correct ?

21 Yes

1 No

What is the usage of NVL?..

Answer / gayathri

NVL function is used to replace the null value by another
value

The syntax for the NVL function is:
NVL( value_in, replace_with )

replace_with is the value that is returned if value_in has
a null value.

Is This Answer Correct ?

17 Yes

0 No

What is the usage of NVL?..

Answer / winnie

In NVL function , it allows to replace with a value when a
null value is encountered.

The syntax is

SELECT NVL(EMP_NAME,'ABC') FROM EMP;

Is This Answer Correct ?

15 Yes

0 No

What is the usage of NVL?..

Answer / goutam

nvl(expr1,expr2)
if expr is null
expr is the converted value.
nvl(name,'not known')
name is null
then it show not known

Is This Answer Correct ?

11 Yes

1 No

What is the usage of NVL?..

Answer / manoranjan sethy

NVL stands for not a value.
Where ever value is not found nvl will convert column and expression as a value

Is This Answer Correct ?

0 Yes

0 No

What is the usage of NVL?..

Answer / nagendra

to convert null values to actual values

Is This Answer Correct ?

3 Yes

5 No

Post New Answer