What is the usage of NVL?
Answers were Sorted based on User's Feedback
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 |
Answer / surendra
it is used to convert null values to any value
Is This Answer Correct ? | 21 Yes | 1 No |
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 |
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 |
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 |
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 an ndf file?
Why left join is used in sql?
Why is stored procedure faster than query?
What is normalisation in sql?
Write a query to get 2nd maximum salary in an employee table ?
69 Answers Accenture, BirlaSoft, Letse, Logica CMG, Qwest, Rheal Software, Saagam, Semantic Space, Tailor Solution, TCS, TinyERP,
What are two virtual tables available during database trigger execution ?
what is a cursor? : Sql dba
What is bind variable in pl sql?
counting the no.of characters occurs in a string by using pl/sql function
what is try_catch block in procedure
What is pl sql variable?
What is the life of an sql statement?