Oracle select 判断

create or replace view V_PD_SELF_EVALUATION as
select PD_PROJECT_EVALUATE.ROW_ID,PD_PROJECT_EVALUATE.FIRST_PROJ,
PD_PROJECT_EVALUATE.PROJECT_CODE,PD_PROJECT_EVALUATE.PROJECT_NAME,PD_PROJECT_EVALUATE.USE_OFFICE,
case PD_PROJECT_EVALUATE.AUDIT_STATUS 
  when '0' then '二级项目绩效自评下发经费处'
    when '1' then '二级项目绩效自评下发经费处领导'
      when '2' then '二级项目绩效自评司局'
        when '3' then '二级项目绩效自评司局处领导'
          when '4' then '二级项目绩效自评经费处'
            when '5' then '二级项目绩效自评经费处领导'
              when '6' then '二级项目绩效自评综合处'
                when '7' then '二级项目绩效自评综合处领导'
                  else '二级项目绩效自评财政库'
                     end AUDIT_STATUS,
PD_PROJ_FUND.YEAR_INITIAL_BUDGET,PD_PROJ_FUND.YEAR_EXECUTE,PD_PROJ_FUND.EXECUTE_RATE_ALL,PD_PROJ_FUND.SCORE,
PD_ANNUAL_PERFORMANCE_MAIN.ANNUAL_GOAL,PD_ANNUAL_PERFORMANCE_MAIN.GOAL_COMPLETION
from PD_PROJECT_EVALUATE PD_PROJECT_EVALUATE
left join PD_PROJ_FUND PD_PROJ_FUND on PD_PROJ_FUND.FROM_ID=PD_PROJECT_EVALUATE.ROW_ID
left join PD_ANNUAL_PERFORMANCE_MAIN PD_ANNUAL_PERFORMANCE_MAIN on PD_ANNUAL_PERFORMANCE_MAIN.FROM_ID=PD_PROJECT_EVALUATE.ROW_ID;
comment on column V_PD_SELF_EVALUATION.ROW_ID is '主键id';
comment on column V_PD_SELF_EVALUATION.FIRST_PROJ is '一级项目';
comment on column V_PD_SELF_EVALUATION.PROJECT_CODE is '财政项目代码';
comment on column V_PD_SELF_EVALUATION.PROJECT_NAME is '项目名称';
comment on column V_PD_SELF_EVALUATION.USE_OFFICE is '司局代码';
comment on column V_PD_SELF_EVALUATION.AUDIT_STATUS is '审核状态';
comment on column V_PD_SELF_EVALUATION.YEAR_INITIAL_BUDGET is '全年预算数';
comment on column V_PD_SELF_EVALUATION.YEAR_EXECUTE is '全年执行数';
comment on column V_PD_SELF_EVALUATION.EXECUTE_RATE_ALL is '执行率';
comment on column V_PD_SELF_EVALUATION.SCORE is '总得分';
comment on column V_PD_SELF_EVALUATION.ANNUAL_GOAL is '预期目标';
comment on column V_PD_SELF_EVALUATION.GOAL_COMPLETION is '实际完成情况';

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值