I want my select statement to return 0 if there is no data
979256Dec 11 2012 — edited Dec 11 2012I want my select statement to return 0 if there is no data ..Example
a_amount NUMBER (14,4);
SELECT DECODE(A_AMOUNT,NULL,0,A_AMOUNT) AS AMOUNT
FROM emp
But the statement above does not return 0 if there is no data .. please help
'