Return null as 0 in oracle select statement
select nvl (sum(com.AMOUNT),0) from EPF e inner join bib_company_transaction com on e.parent_oid = com.trnx_id where status='T' and com.UPDATED_DATE between to_date('20111018', 'yyyymmdd') and to_date('20111019', 'yyyymmdd')
No comments:
Post a Comment