select
'private String'||
(case
when t.type='3' then '[]'
when t.type='4' then '[]'
else
''
end)
||' '||t.name,t.wtd_name_id from jc_wtd_fields t order by t.wtd_name_id,t.name
'private String'||
(case
when t.type='3' then '[]'
when t.type='4' then '[]'
else
''
end)
||' '||t.name,t.wtd_name_id from jc_wtd_fields t order by t.wtd_name_id,t.name