select case t.yj_type
when '体检复查' then
'体检复查111111111111'
else
t.yj_type
end,
t.*
from T_WJ_F3_YJB t;
select decode(t.yj_type, '体检复查', '体检复查111111111111', t.yj_type),
t.*
from T_WJ_F3_YJB t;
select t.yj_type, t.*
from T_WJ_F3_YJB t
where t.yj_type = '体检复查'
and to_char(t.tbrq, 'yyyy-mm-dd') = '2013-06-26'
or t.yj_type = '职业禁忌'
and to_char(t.tbrq, 'yyyy-mm-dd') = '2013-06-25';
when '体检复查' then
'体检复查111111111111'
else
t.yj_type
end,
t.*
from T_WJ_F3_YJB t;
select decode(t.yj_type, '体检复查', '体检复查111111111111', t.yj_type),
t.*
from T_WJ_F3_YJB t;
select t.yj_type, t.*
from T_WJ_F3_YJB t
where t.yj_type = '体检复查'
and to_char(t.tbrq, 'yyyy-mm-dd') = '2013-06-26'
or t.yj_type = '职业禁忌'
and to_char(t.tbrq, 'yyyy-mm-dd') = '2013-06-25';