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