are you getting null values for count(*) ? if that is the case you may use
instead nvl(count(*),0)
hope this helps
regards
Gopa
On Jan 19, 2011 9:53 AM, "faizal mangattil`" <faizmangat...@gmail.com>
wrote:
created one report with this query
SELECT COUNT (*), est_name, category_description
FROM bl_tb_external_issues ei,
bl_tb_external_issues_dtl et,
bl_tb_blood_units bu,
bl_tb_products bp,
bl_tb_blood_categories bc,
mst_tb_establishment_mast em
WHERE
ei.INSTID=em.EST_CODE and
ei.issueid = et.issueid
AND et.unitid = bu.unitid
AND bu.product_id = bp.product_id
AND bp.blood_category_id = bc.blood_category_id
AND ei.status = 'A'
GROUP BY est_name, category_description;
I want to fill zero in blank cell. see the attached file.
if anybody can help. it will be appreciable.
--
You received this message because you are subscribed to the Google
Groups "Oracle PL/SQL" group.
To post to this group, send email to Oracle-PLSQL@googlegroups.com
To unsubscribe from this group, send email to
oracle-plsql-unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/Oracle-PLSQL?hl=en
--
You received this message because you are subscribed to the Google
Groups "Oracle PL/SQL" group.
To post to this group, send email to Oracle-PLSQL@googlegroups.com
To unsubscribe from this group, send email to
oracle-plsql-unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/Oracle-PLSQL?hl=en
