oracle中case when语法

来源:互联网 发布:ec软件下载2016 编辑:程序博客网 时间:2024/05/18 22:11

  Case
                  When Fd_Business.Amount_Debit > 0 And
                       Fd_Business.Syscreate_Type <> 5 And
                       Fd_Business.Fd_Fund_Account_Id In
                       (Select Fd_Fund_Account_Id
                          From Fd_Fund_Account Ffa
                         Where Ffa.Fund_Account_Type = 'C') Then
                   '现金收款'
                  
                  
                  When Fd_Business.Amount_Debit > 0 And
                       Fd_Business.Syscreate_Type <> 5 And
                       Fd_Business.Fd_Fund_Account_Id In
                       (Select Fd_Fund_Account_Id
                          From Fd_Fund_Account Ffa
                         Where Ffa.Fund_Account_Type = 'B') Then
                   '银行收款'
                  When Fd_Business.Amount_Credit > 0 And
                       Fd_Business.Syscreate_Type <> 5 And
                       Fd_Business.Syscreate_Type <> 8 and
                       Fd_Business.Fd_Fund_Account_Id In
                       (Select Fd_Fund_Account_Id
                          From Fd_Fund_Account Ffa
                         Where Ffa.Fund_Account_Type = 'C') Then
                   '现金付款'
                  When Fd_Business.Amount_Credit > 0 And
                       Fd_Business.Syscreate_Type = 8 And
                       Fd_Business.Fd_Fund_Account_Id In
                       (Select Fd_Fund_Account_Id
                          From Fd_Fund_Account Ffa
                         Where Ffa.Fund_Account_Type = 'C') Then
                   '现金工资发放'
                  When fd_Business.Amount_Credit > 0 And
                       Fd_Business.Syscreate_Type <> 5 And
                       Fd_Business.Syscreate_Type <> 8 and
                       Fd_Business.Fd_Fund_Account_Id In
                       (Select Fd_Fund_Account_Id
                          From Fd_Fund_Account Ffa
                         Where Ffa.Fund_Account_Type = 'B') Then
                   '银行付款'
                  When fd_Business.Amount_Credit > 0 And
                       Fd_Business.Syscreate_Type = 8 And
                       Fd_Business.Fd_Fund_Account_Id In
                       (Select Fd_Fund_Account_Id
                          From Fd_Fund_Account Ffa
                         Where Ffa.Fund_Account_Type = 'B') Then
                   '银行工资发放'
                  When Fd_Business.Syscreate_Type = 5 Then
                   '银行存取款'
                  Else
                   '其他'
                End Ontheway_Billno,

原创粉丝点击