NVL lets us to replace null (returned as blank) with a string in the results of a query. For example,
NVL(value1, value2)
If value1 is null then it will be replaced with value2.
Javascript:
function nvl(value,nullValue){
var output = "";
if (value == null || value == "")
{
output = nullValue;
}else {
output = value;
}
return output;
}
No comments:
Post a Comment