加粗样式
有两种方式:
第一种,使用decode函数
SELECT *
FROM prj_project pp
WHERE (case
when (case
when pp.business_type = ‘LEASE’ then
1
else
0
end) = 1 then
pp.business_type
else
pp.document_type
end) = (case
when (case
when pp.business_type = ‘LEASE’ then
1
else
0
end) = 1 then
‘LEASE’
else
‘PRJLB’
end)
and pp.company_id = 2;
第二种,使用case when
SELECT *
FROM prj_project pp
WHERE decode(pp.business_type, ‘LEASE’, 1, 0) = 1
or pp.document_type = ‘PRJLB’
and pp.company_id = 2;