Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
kawadeprasad
Starting Member
13 Posts |
 Posted - 2012-06-04 : 06:40:46
|
Hi,
I would like to know the difference bet NVL and COALESCE.
performance wise which is better?
what are the merits and demerits of each of those?
Where it's recommended to use?
Thanks in advance!!!
-Prasad |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2012-06-04 : 09:25:12
|
NVL is an Oracle feature, IIRC. SQLTeam is a Microsoft SQL Server website. You can find more information on NVL here: http://www.techonthenet.com/oracle/functions/nvl.php
The most basic difference is that COALESCE can evaluate multiple replacement values, while NVL can only accept one. If there is a performance difference it's probably negligible. |
 |
|
|
|
|
|
difference bet NVL and COALESCE