oracle case when与decode语句

今天遇到sql语句中要判断不知道怎么做，于是找了一下，哈哈oracle挺强的
先看case when 语句：
    select case when c.store_amount-c.amount > 0 then '盘盈'
      when c.store_amount-c.amount < 0 then '盘亏'
            else '持平' end from sghis.pa_pham_check_detail c'
decode语句：
    select t.employee_id,
       t.employee_name,
       decode(t.sex , '1' , '男', '2' , '女',  ' ') as sex,
       t.age,
       a.office_name,
       t.office_code,
       b.dmmc  || ' ' as work_p,
       t.work_position,
       t.doctor_code || ' ' as doctor_code,
       e.dmmc,
       t.technic_title,
       t.py_code,
       t.wb_code
  from sghis.hd_employee t,
       sghis.hd_office_dict a,
       (select c.dmsb, c.dmmc
          from sghis.hd_gy_dmzd c
         where c.dmlb = '7'
           and c.xtsb = '0') b,
       (select d.dmsb, d.dmmc
          from sghis.hd_gy_dmzd d
         where d.dmlb = '8'
           and d.xtsb = '0') e
where t.office_code = a.office_code
   and t.work_position = b.dmsb(+)
   and t.technic_title = e.dmsb(+)
   and t.hos_id = '$P!{hos_id}'
   and t.employee_name like '%$P!{employee_name}%'
   and t.office_code like '%$P!{office_code}%'
   and t.py_code like '%$P!{py_code}%'
   and t.wb_code like '%$P!{wb_code}%'
order by t.office_code