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 built in functions of sql?

975

Lookups are a key component in sql server integration services (ssis). Explain its purpose?

952

Define select, insert, create, delete, update, drop keywords

993

What is sql analyzer?

956

Are pl sql variables case sensitive?

996

What is materialized view. What are different methods of refresh?

1327

Why cannot I use bind variables in ddl/scl statements in dynamic sql?

1130

Why join is faster than subquery?

1039

What is the current version of postgresql?

1002

How do I send sql query results to excel?

1002

Explain the working of primary key?

1031

How does pl sql work?

908

How many primary keys can a table have?

949

what is log shipping? : Sql dba

1055

What are the types of variables use in pl sql?

964