创智java信息
BeanHelper bean助手
DTO(data transfer object):数据传输对象,
transfer 转移
select t.*,
DECODE(t.AAZ066,
'542600', t.AAF021,
'542623',t.AAF020,
'其他') 类别 from AF06 t
select t.*,
DECODE(t.AAZ066,
'542600', '男',
'542623','女',
'其他') 类别 from AF06 t
select
( case when t.AAZ066='542600' then 1 else 0 end ) 主键 ,
t.*
from AF06 t
select
( case
when t.AAZ066='542600' then 1
when t.AAZ066='542622' then 5
else 0 end ) 主键 ,
t.*
from AF06 t