Saturday, October 22, 2011

Return null as 0 in oracle select statement

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')
Post a Comment
Related Posts Plugin for WordPress, Blogger...