摘要： 1, 有case情况。select trunc(exf_payment_receipt.work_date),exf_payment_receipt.exchange_code,exf_payment_receipt.bill_no,exf_payment_type.name, exf_payment_receipt.total_money,case exf_payment_receipt.status when '0' then '正常' else '已撤销' end,case exf_payment_receipt.flag when  阅读全文