| |
GeekInterview.com > Interview Questions > Oracle > General
| Print | |
Question: explaint the nvl2 function
|
| June 06, 2008 03:48:16 |
#7 |
| nandk.sharma |
Member Since: June 2008 Total Comments: 10 |
RE: explaint the nvl2 function
|
| nvl2 function is the upgraded form of nvl function.In nvl function we need to pass two parameters.i.e. nvl(interest_rate ,returned_value) if the value of interest_rate is null then the nvl function returns the value of second parameter 'returned_value'.In nvl2 function we need to pass three parameters .i.e. nvl2 (interest_rate,returned_value_if_not_null,returned_value_if_null)if the value of interest_rate is null then the nvl function returns the value of the third parameter 'returned_value_if_null' else it returns the value of the second parameter 'returned_value_if_not_null'. |
| |
Back To Question | |
