Converts Null value to Absolute for calculation. Ex : nvl(commission,0)

What is nvl function?

Question Posted / dinesh kumar

Answer Posted / dinesh kumar

Converts Null value to Absolute for calculation.

Ex : nvl(commission,0) returns 0 when commission is null.

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What are all ddl commands?

1015

Is ms sql is free?

961

when MSQL8.0 is in market

2016

Can a trigger call a stored procedure?

1004

what are the security recommendations while using mysql? : Sql dba

1051

What is data types in sql?

951

What are the different ways to optimize a sql query?

891

Why self join is used in sql?

919

What are the different ddl commands in sql?

1067

explain advantages of myisam over innodb? : Sql dba

1017

How many triggers can be applied to a table?

995

Can we use two order by clause in query?

920

What is package in pl sql?

964

How exception handling is done in advance pl/sql?

920

What is basic structure of pl sql?

990