select * from PQS_YALTD a
where
CASE a.start_yn
when '0' then to_number(a.start_point) < 25
when '1' then to_number(a.start_point) <= 25
END;个人认为这样写根本就没有任何意义。
where
CASE a.start_yn
when '0' then to_number(a.start_point) < 25
when '1' then to_number(a.start_point) <= 25
END;个人认为这样写根本就没有任何意义。
(a.start_yn='0' and to_number(a.start_point)<25)
or
(a.start_yn='1' and to_number(a.start_point)<=25)case when 在ORACLE中正象你说的不能用表达式