This shows you the differences between two versions of the page.
|
dev:sql:functions:nvl [2016/06/28 22:38] |
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}} | ||