In NVL function , it allows to replace with a value when a null value is

What is the usage of NVL?

Question Posted / winnie

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

Please Help Members By Posting Answers For Below Questions

Why do we need pl sql?

972

How does index help in query performance?

1028

Explain the difference between drop and truncate commands in sql?

1046

What are the types of join and explain each?

1032

What is a memo field?

967

How do sql databases work?

990

What is natural join in sql?

983

Can we create clustered index without primary key?

962

what is the difference between undefined value and null value? : Sql dba

1098

how is exception handling handled in mysql? : Sql dba

1075

What is primary key and foreign key with example?

929

what is 'mysqlimport'? : Sql dba

1044

Could you please provide oca (oracle 10g) dumps for my certification ?

5156

what is a record in a database ? : Sql dba

1061

what are date and time data types? : Sql dba

981