Posted on Published: 2025-06-03 14:52 Case statement in where clasue Category DATABASE ExampleWHERE ( 1 = CASE WHEN <column_a> != <column_b> AND <column_c> = 1 THEN 1 WHEN <column_a> = NVL( <column_b>, -1 ) THEN 1 ELSE 0 END )