你可以在when的情况下添加额外的条件：

where
  case
    when :attribute = 'Full Run'
    then 1
    when :attribute='Changed Attribute'
    and max_update_date >=
      Nvl(
        (SELECT Max(processstart)
        FROM   fusion.ess_request_history erh,
               fusion.ess_request_property erp
        WHERE  erh.requestid = erp.requestid
        AND state = 12
        AND erp.NAME = 'reportID'
        AND erp.value LIKE '/Custom/Integrations/Extract.xdo'
        ),max_update_date)
    then 1
    else 0
  end = 1

字符串
但是，忘记case表达式，只使用布尔逻辑会更简单：

where :attribute = 'Full Run'
or (
  :attribute='Changed Attribute'
  and max_update_date >=
    Nvl(
      (SELECT Max(processstart)
      FROM   fusion.ess_request_history erh,
             fusion.ess_request_property erp
      WHERE  erh.requestid = erp.requestid
      AND state = 12
      AND erp.NAME = 'reportID'
      AND erp.value LIKE '/Custom/Integrations/Extract.xdo'
      ),max_update_date)
)

型

请给予旧的带有表列表的sintax，使用Join ON（）sintax。基本上，如果你想在：attribute = 'Full Run'时显示所有行，并且你想在：attribute不同的情况下过滤行，那么你可以在：attribute = 'Full Run'时将Where子句中的独特列与其自身进行比较（始终为true），并在case表达式中将真实的条件放在else或另一个中。
类似下面的东西：

WITH        --  S a m p l e    D a t a :
    tbl_1 AS
        (   Select 1 "ID", 'A' "A_LETTER", 101 "A_NUMBER" From Dual Union ALl
            Select 2 "ID", 'B' "A_LETTER", 102 "A_NUMBER" From Dual Union ALl
            Select 3 "ID", 'C' "A_LETTER", 103 "A_NUMBER" From Dual Union ALl
            Select 4 "ID", 'D' "A_LETTER", 104 "A_NUMBER" From Dual Union ALl
            Select 5 "ID", 'E' "A_LETTER", 105 "A_NUMBER" From Dual
        ),
    tbl_2 AS
        (   Select 1 "ID", 'A104' "COMB" From Dual Union ALl
            Select 2 "ID", 'X102' "COMB" From Dual Union ALl
            Select 3 "ID", 'C103' "COMB" From Dual Union ALl
            Select 4 "ID", 'D104' "COMB" From Dual Union ALl
            Select 5 "ID", 'Y105' "COMB" From Dual 
        )
--  M a i n   S Q L
Select      t1.ID, t1.A_LETTER, t1.A_NUMBER, t2.COMB
From        tbl_1 t1
Inner Join  tbl_2 t2 ON(t1.ID = t2.ID)
Where       t2.COMB = Case When :attribute = 'Full Run' Then t2.COMB Else t1.A_LETTER || t1.A_NUMBER End

/*  attribute = 'Full Run'
        ID A_LETTER   A_NUMBER COMB
---------- -------- ---------- ----
         1 A               101 A104
         2 B               102 X102
         3 C               103 C103
         4 D               104 D104
         5 E               105 Y105   */
/*  other attribute
        ID A_LETTER   A_NUMBER COMB
---------- -------- ---------- ----
         3 C               103 C103
         4 D               104 D104    */

字符串