What is nvl function?

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to run pl/sql statements in sql*plus?

594


What is the unique index?

526


What are sql objects?

546


What is before trigger?

558


What is sql scripting?

563






What is range partitioning?

522


How do you identify a primary key?

635


Differentiate pl/sql and sql?

565


How to take user input in pl sql?

705


What are the set operators in sql?

561


Is microsoft sql free?

604


How to use sql statements in pl/sql?

585


Why trigger is used in sql?

535


Show the two pl/sql cursor exceptions.

616


What are the basic techniques of indexing?

577