Tuesday, June 8, 2021

OIC - NVL in javascript

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

Featured Post

End to End Securing Data in Oracle Integration Cloud (OIC) with OCI Vault: AES for Encryption & Decryption & RSA for Signing and verification | Implement message-level encryption in Oracle Integration using OCI Vault

Scenario: A company is integrating Oracle Integration Cloud (OIC) with an external financial system to exchange sensitive payroll data secur...