What is nvl function?

Answer Posted / the superstar rajnikanth

NVL(F,E)
if F is null,it returns expression E.F can be of any type.
the type of E should be the same as that on the left-hand side.

Is This Answer Correct ?    4 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How do I edit a trigger in sql developer?

539


Why do we need sharding?

529


What is structural independence and why is it important?

548


Can we perform dml in function?

593


Explain select statements in sql?

589






How do I run a sql trace?

521


What is a primary key called that is made up of more than one field?

797


How do I remove sql plus from windows 10?

567


What is partition by in sql?

569


What is sqlcontext?

550


What is the non-clustered index in sql?

587


What is sql trigger example?

540


Can we use pl sql in mysql?

519


Why we use joins in sql?

537


What is the cause of mutating table error and how can we solve it?

601