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

Explain cursor types?

578


What is join view in sql?

510


Are null values same as that of zero or a blank space?

529


How can one get sql*loader to commit only at the end of the load file? : aql loader

561


What are the different datatypes available in PL/SQL?

561






Can we use ddl commands in pl sql?

554


What is difference between table and view?

518


Where the sql database files are stored?

481


What is a parameter query?

621


What is program debugging?

556


how to convert dates to character strings? : Sql dba

533


how are mysql timestamps seen to a user? : Sql dba

559


What is meant by temporal data?

538


What is the difference between in and between in sql?

574


What are all different types of collation sensitivity?

523