sql code:
select * from table_name t
where (case when t.table_column=‘条件‘ then t.table_column
when t.table_column=‘条件‘ then t.table_column end)=‘条件‘
my sql code:
-- 测试sql
SELECT *FROM PROJECT_INFO pi
Oracle sql where后面的多条件case when判断执行
原文：https://www.cnblogs.com/wk814007042/p/11537749.html