NVL2

=**NVL2 ** = 


===NVL2(expression 1 value that may contain a null, expression 2 value to return if expression 1 is not null, expression 3 value to replace if expression 1 is null) ===

__Description __
 The NVL2 function evaluates with three values. If the first value is not null, then the NVL 2 function returns the second expression. If the first value is null, then the third expression is returned.



 * LAST_NAME || NVL2(DEPARTMENT_ID, 'HERE', 'N/A) ||
 * Zlotkey || Here ||
 * <span style="font-family: 'Courier New',Courier,monospace;">Abel || <span style="font-family: 'Courier New',Courier,monospace;">Here ||
 * <span style="font-family: 'Courier New',Courier,monospace;">Taylor || <span style="font-family: 'Courier New',Courier,monospace;">Here ||

<span style="font-family: 'Courier New',Courier,monospace;">FROM employees

 * <span style="font-family: 'Courier New',Courier,monospace;"><span style="font-family: 'Courier New',Courier,monospace;"> FIRST_NAME || <span style="font-family: 'Courier New',Courier,monospace;">NVL2(COMMISSION_PCT,'HERE','NONE') ||
 * <span style="font-family: 'Courier New',Courier,monospace;">Steven || <span style="font-family: 'Courier New',Courier,monospace;">None ||
 * <span style="font-family: 'Courier New',Courier,monospace;">Neena || <span style="font-family: 'Courier New',Courier,monospace;">None ||
 * <span style="font-family: 'Courier New',Courier,monospace;">Lex || <span style="font-family: 'Courier New',Courier,monospace;">None ||
 * <span style="font-family: 'Courier New',Courier,monospace;">Jennifer || <span style="font-family: 'Courier New',Courier,monospace;">None ||
 * <span style="font-family: 'Courier New',Courier,monospace;">Shelley || <span style="font-family: 'Courier New',Courier,monospace;">None ||
 * <span style="font-family: 'Courier New',Courier,monospace;">William || <span style="font-family: 'Courier New',Courier,monospace;">None ||
 * <span style="font-family: 'Courier New',Courier,monospace;">Eleni || <span style="font-family: 'Courier New',Courier,monospace;">Here ||
 * <span style="font-family: 'Courier New',Courier,monospace;">Ellen || <span style="font-family: 'Courier New',Courier,monospace;">Here ||
 * <span style="font-family: 'Courier New',Courier,monospace;">Johnathon || <span style="font-family: 'Courier New',Courier,monospace;">Here ||
 * <span style="font-family: 'Courier New',Courier,monospace;">Kimberly || <span style="font-family: 'Courier New',Courier,monospace;">Here ||

<span style="font-family: 'Courier New',Courier,monospace;">FROM f_staffs

 * <span style="font-family: 'Courier New',Courier,monospace;">FIRST_NAME || <span style="font-family: 'Courier New',Courier,monospace;">NVL2(MANAGER_BUDGET,'MANY','N/A') ||
 * <span style="font-family: 'Courier New',Courier,monospace;">Sue || <span style="font-family: 'Courier New',Courier,monospace;">n/a ||
 * <span style="font-family: 'Courier New',Courier,monospace;">Bob || <span style="font-family: 'Courier New',Courier,monospace;">n/a ||
 * <span style="font-family: 'Courier New',Courier,monospace;">Monique || <span style="font-family: 'Courier New',Courier,monospace;">Available ||