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 benefits of stored procedures?

1072

How do I create a sql script?

1101

What is crud sql?

984

How can we solve sql error: ora-00904: invalid identifier?

1246

How to start oracle sql developer?

1035

What is a temp table?

1024

what is a record in a database ? : Sql dba

1063

What are the two types of periodical indexes?

940

What is the difference between execution of triggers and stored procedures?

1115

What is autocommit sql?

993

what are string data types? : Sql dba

1040

How do you pronounce sql?

1011

Explain the update statement in sql

992

What do you mean by stored procedures? How do we use it?

996

When is a declare statement required?

1138