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 are local and global variables and their differences?

0 Answers  

What are triggers and its types?

0 Answers  

a. Can you delete data from a View. b. If Yes, can you delete it if there are multiple tables c. If No, can you delete if there is single source table which is joining.

1 Answers   CGI,

SELECT ROUND(TRUNC(MOD(1600,10),-1),2) FROM dual;

10 Answers  

What is pl sql block in dbms?

0 Answers  

What is composite primary key in sql?

0 Answers  

what is an alias command? : Sql dba

0 Answers  

What is string data type in sql?

0 Answers  

How global cursor can be declare with dynamic trigger ?

0 Answers  

What does joining a thread mean?

0 Answers  

How to display the contents of a current record fetched in a reference cursor?

2 Answers  

Can a primary key be a foreign key?

0 Answers