At 12:03 PM 6/17/98 +0000, Jose' Soares Da Silva wrote: >> Jose' Soares Da Silva writes: >> > SELECT name,NVL(salary)+100 AS dream FROM emp; >> > name |dream >> > -----------+----- >> > Sam | 1300 >> > Claire | 5100 >> > Bill | 4300 >> > Ginger | 4900 >> > NULL VALUES| <--- I expected 100 here. >> > (5 rows) SELECT name, NVL(salary, 0) + 100 AS dream FROM emp; NVL() takes two values: the column/variable, and the value to use if NULL. -- Robin Thomas [EMAIL PROTECTED]
- [GENERAL] COALESCE() or NVL() Jose' Soares Da Silva
- Re: [GENERAL] COALESCE() or NVL() rmcm
- Re[2]: [GENERAL] COALESCE() or NVL() Robin Thomas
- Re[2]: [GENERAL] COALESCE() or NVL() Sferacarta Software