This article is a mirror article of machine translation, please click here to jump to the original article.

Architect_Programmer_Code Agriculture Network»Architect › Database & Database › Oracle › What are the functions of Oracle's NVL and NVL2, and what is the difference between the two?
View: 11852|Reply: 0

[Source] What are the functions of nvl and nvl2 in Oracle, and what is the difference between the two?

[Copy link]
Posted on 3/22/2015 8:52:05 AM | | | |
NVL2(expr1,expr2,expr3) function: If the value of the parameter expression expr1 is NULL, the NVL2() function returns the value of the parameter expression expr3; If the value of the parameter expression expr1 is not NULL, the NVL2() function returns the value of the parameter expression expr2. NVL(string1, replace_with) function: If string1 is NULL, the NVL function returns the value of replace_with, otherwise the value of string1, if both parameters are NULL, it returns NULL.






Previous:Doraemon: Walk With Me (2014)
Next:SqlServer naming convention

Related Posts
Disclaimer:
All software, programming materials or articles published by Code Farmer Network are only for learning and research purposes; The above content shall not be used for commercial or illegal purposes, otherwise, users shall bear all consequences. The information on this site comes from the Internet, and copyright disputes have nothing to do with this site. You must completely delete the above content from your computer within 24 hours of downloading. If you like the program, please support genuine software, purchase registration, and get better genuine services. If there is any infringement, please contact us by email.
Mail To:help@itsvse.com