oracle中使用where case when
SELECT t.dict_code
FROM tb_dict_contract_dtl t
WHERE
t.DEAL_DATE = CASE WHEN t.DEAL_DATE ='20210301' then '20210302' ELSE '20210301' END
SELECT t.dict_code
FROM tb_dict_contract_dtl t
WHERE
t.DEAL_DATE = CASE WHEN t.DEAL_DATE ='20210301' then '20210302' ELSE '20210301' END