This is the blog dedicated to Oracle Applications users. Here I will be posting information on Oracle Application which will have technical, functional and Administration related topics. Although the site may be more beneficial to technial junkies.
Please remember to visit site regularly as it will be updated quite often and do remember to encourage me by posting your valuable comments.
Thanks,
Suresh Vaishya
In Oracle, the NVL2 function extends the functionality found in the NVL function. It can be used to substitute a value when a null value is encountered as well as when a non-null value is encountered.
The syntax for the NVL2 function is:
NVL2( string1, value_if_NOT_null, value_if_null )
string1 is the string to test for a null value.
value_if_NOT_null is the value returned if string1 is not null.
value_if_null is the value returned if string1 is null.
Copyright (c) All rights reserved. Presented by Suresh Vaishya
View Suresh Vaishya's profile
0 Comments:
Post a Comment