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 Overloading of procedures ?

2 Answers  

What is AUTH_ID and AUTH_USER in pl/sql ?

0 Answers   INDUS,

How do you write a subquery?

0 Answers  

Explain normalization and what are the advantages of it?

0 Answers  

How to change sql*plus system settings?

0 Answers  

What do we need to check in database testing?

0 Answers  

What is acid property in a database?

0 Answers  

What is a behavioral trigger?

0 Answers  

Display the total debit counts, total credit counts, sum of total debits, sum of total credits from an employee's transaction table (a single table) containing the following columns. Transaction_number Transaction_amount Transaction_date Transaction_type --> tells if the amount is a credit or a debit. As the query alone is important, the table is left with specifying just the field's name. Pls help me with this query.

3 Answers   iNautix, Oracle,

what are the differences among rownum, rank and dense_rank? : Sql dba

0 Answers  

What is sql comments?

0 Answers  

How to recompile a already made trigger?

2 Answers