How to display non existent data as 0 in Oracle
in my table there refno,purchase,sale,acc_type are four columns.i have to sum(b) and sum(c). for a perticular date.but the query should show 0 for clumn b & c where there no value has been entered.suppose purchase,sale, are summing per month.but in some month there is no entry for a,b,c,d.so how to show them for that month as 0 for all columns.?
BUT there is no entry for the month suppose mar or april.then there will be no record for mar or aprilthere is no columns for those months becuse i have not entered any thing for those months.i only entered for sales/purchase
[Br _extended="true" />[Br _extended="true" />plz suggest how i will write.
Software/Hardware used:
oracle
BUT there is no entry for the month suppose mar or april.then there will be no record for mar or aprilthere is no columns for those months becuse i have not entered any thing for those months.i only entered for sales/purchase
[Br _extended="true" />[Br _extended="true" />plz suggest how i will write.
Software/Hardware used:
oracle
ASKED:
August 11, 2010 3:37 AM
UPDATED:
August 11, 2010 1:43 PM
Answer Wiki:
Deb4u, this seems to be the same question as this one (which you posted yesterday):
<a href="http://itknowledgeexchange.techtarget.com/itanswers/to-display-not-exit-data/">To display not exit data in oracle</a>
If you want to provide more details or ask for clarification, please continue the discussion in the same thread.
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
