select ca.case_no     as 案件编号,
       ca.per_name    as 报案人姓名,
       ca.per_phone   as 报案人手机号,
       ca.per_sfzh    as 报案人身份证,
       sd.dict_value1 as 所属*,
       ca.case_desc   as 简要案情,
       to_char(ca.create_date, 'yyyy-MM-dd HH24:mi:ss') as 创建时间
  from (select *
          from T_A_CASEINFO ca
         where ca.del = '0'
           and ca.case_flag != '01049901'
           and ca.case_flag != '01049902'
           and ca.create_date between
               to_date('2021-01-01 00:00:00', 'yyyy-MM-dd HH24:mi:ss') and
               to_date('2021-09-30 23:59:59', 'yyyy-MM-dd HH24:mi:ss')) ca,
       SYS_DICT sd
 where ca.occurr_gxs = sd.dict_key