Quick Search:
 
 Oracle PL/SQL: NVL Jump to:  
Category: >> Oracle PL/SQL >> NVL  

<< lastnext >>

Snippet Name: NVL

Description: Returns a Value if the Expression IS NULL

Also see:
» IS NOT NULL
» Data Types

Comment: (none)

Language:
Highlight Mode: PLSQL
Last Modified: March 07th, 2009

SELECT f_name, NVL(middle_name, 'No middle name'), last_name
FROM employees
WHERE hire_date > SYSDATE - 60;
 
SELECT NVL(bonus, 0)
FROM emp_bonuses
WHERE last_name = 'Spasky';


 
   Home |    Search |    Code Library |    Sponsors |    Privacy |    Terms of Use |    Contact Us © 2003 - 2024 psoug.org