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')

No comments:

Related Posts Plugin for WordPress, Blogger...