Oracle/PLSQL: NVL Function

来源:互联网 发布:怎么重置网络 编辑:程序博客网 时间:2024/06/05 23:55

In Oracle/PLSQL, the NVL function lets you substitute a value when a null value is encountered.

The syntax for the NVL function is:

NVL( string1, replace_with )

string1 is the string to test for a null value.

replace_with is the value returned if string1 is null.