nvl(expr1,expr2) if expr is null expr is the converted value. nvl(name,

What is the usage of NVL?

Question Posted / goutam

Answer Posted / 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

Please Help Members By Posting Answers For Below Questions

What are the two virtual tables available at the time of database trigger execution?

1222

what are all the different normalizations? : Sql dba

1036

What are the types of join in sql?

1098

Why do we need sharding?

986

What is foreign key and example?

931

Can %notfound return null after a fetch?

1055

what are the system privileges that are required by a schema owner (user) to create a trigger on a table?

1065

How do we use distinct statement? What is its use?

1029

Explain the uses of database trigger.

1112

how to create a new view in mysql? : Sql dba

931

How do I start pl sql?

945

How are functions and procedures called in PL/SQL?

1225

How do sql triggers work?

1035

When are we going to use truncate and delete?

984

What are the different types of dbms?

1009