This shows you the differences between two versions of the page.
— |
dev:sql:functions:nvl [2016/06/28 22:38] (current) |
||
---|---|---|---|
Line 1: | Line 1: | ||
+ | {{page>:top_add&nofooter&noeditbtn}} | ||
+ | <html><div align="center"><span style="color:red">DRAFT</span></div></html> | ||
+ | ====== Omnidex SQL Function: NVL ====== | ||
+ | {{page>:sql_bar&nofooter&noeditbtn}} | ||
+ | ^See Also:^ [[ dev:sql:orafunctions:chr | CHR ]] ^ [[ dev:sql:orafunctions:instr | INSTR ]] ^ [[ dev:sql:orafunctions:new_time | NEW_TIME ]] ^ [[ dev:sql:orafunctions:nvl | NVL ]] ^ [[ dev:sql:orafunctions:substr | SUBSTR ]] ^ [[ dev:sql:orafunctions:sys_extract_utc | SYS_EXTRACT_UTC ]] ^ [[ dev:sql:orafunctions:sysdate | SYSDATE ]] ^ [[ dev:sql:orafunctions:systimestamp | SYSTIMESTAMP ]] ^ [[ dev:sql:orafunctions:to_date | TO_DATE ]] ^ [[ dev:sql:orafunctions:to_number | TO_NUMBER ]] ^ | ||
+ | ===== Description ===== | ||
+ | The NVL function Returns expression2 if expression1 is NULL. The return datatype is the same as expression1. | ||
+ | |||
+ | ===== Syntax ===== | ||
+ | NVL(expression1, expression2) | ||
+ | |||
+ | {{page>:bottom_add&nofooter&noeditbtn}} |