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

What is execute immediate?

0 Answers  

if we give update table_name set column_name= default. what will happen? its given in pl sql block.what will hapen?

5 Answers   iFlex,

What is a crud api?

0 Answers  

How to call the function and Procedure in trigger?

3 Answers   IBM,

How to return more than one value from a function?

11 Answers   Satyam,

how is myisam table stored? : Sql dba

0 Answers  

Explain mutating table error.

0 Answers  

What is the basic form of sql query?

0 Answers  

Explain what is table in a database?

0 Answers  

i don't want the message as 14 rows updated just it should update what it will do

4 Answers  

How many sql are there?

0 Answers  

What are the syntax and use of the coalesce function?

0 Answers