Answer / shailesh

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

Answer / surendra

it is used to convert null values to any value

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.

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;

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

Answer / manoranjan sethy

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

Answer / nagendra

to convert null values to actual values

Explain how can you save or place your msg in a table?

0 Answers  

Is like operator in sql case sensitive?

0 Answers  

What is a database event trigger?

0 Answers  

What is cte sql?

0 Answers  

What are the attributes of SQL*PLUS ?

2 Answers   Dream Careers, Oracle,

Does postgresql run on the cloud?

0 Answers  

What is Difference Between Unique and Primary Key Constraints?

0 Answers   Wipro,

Which sql statement is used to return only different values?

0 Answers  

What is the meaning of disabling a trigger?

0 Answers  

declare lowerl number:= 1; upperl number:= 3; num varchar2(10); begin for i into lowerl..upperl loop num:=num||to_char(lowerl); if i=3 then upperl:=5; end loop; message(num); What will be the output ?

3 Answers   Oracle,

What program will open a mdb file?

0 Answers  

What is rownum in sql?

0 Answers