areatext当中不能加空格

areatext中间不能加空格

areatext中间不能加空格;

js出错看行数时，用看源代码；

 ^p，ue里加空格时用这个；

 

CREATE OR REPLACE VIEW V_ACDM_CHARGE_STAT AS
select R.RK,
       R.ID,
       R.FLOW_ID, --流程id
       R.CHARGE, --罪名id
       R.AMOUNT, --金额
       R.FLAG, --状态
       R.TACHE_ID, --环节id
       R.OTHER_CHARGE, --其他罪名
       D.CHARGE_NAME --罪名名称
  from (select rank() over(partition by T.TACHE_ID order by T.ID ASC) rk,
               T.*
          from t_acdm_charge_info T
         WHERE T.FLAG IS NULL) R,
       T_ACDM_CHARGE_DIC D
 where R.CHARGE = D.ID
   AND R.rk = 1
UNION ALL
SELECT R.RK,
       R.ID,
       R.FLOW_ID, --流程id
       R.CHARGE, --罪名id
       R.AMOUNT, --金额
       R.FLAG, --状态
       R.TACHE_ID, --环节id
       R.OTHER_CHARGE, --其他罪名
       D.CHARGE_NAME --罪名名称
  FROM (select rank() over(partition by T.TACHE_ID order by T.FLAG DESC, T.ID ASC) rk,
               T.*
          from t_acdm_charge_info T
         WHERE T.FLAG IS NOT NULL) R,
       T_ACDM_CHARGE_DIC D
 where R.CHARGE = D.ID
   AND R.rk = 1;