when DATA_TYPE = 'NUMBER' then
case data_scale
when 0 then
'Int16'
else
'Decimal'
end
else
initcap(A.DATA_TYPE)
end || ',"' || LOWER('v_'||A.COLUMN_NAME) || '",MU.' || A.COLUMN_NAME ||
'));'
from all_tab_columns A
where A.TABLE_NAME = 'T_USER';
转载于:https://my.oschina.net/u/2446847/blog/1536240