select 'iParams.Add(OracleHelper.InParam(OracleDbType.' || case
when DATA_TYPE = 'NUMBER' then
case data_scale
when 0 then
'Int16'
else
'Decimal'
end
else
initcap(A.DATA_TYPE)
end || ',"' || LOWER(A.COLUMN_NAME) || '",enty.' || A.COLUMN_NAME ||
'));'
from all_tab_columns A
where A.TABLE_NAME = 'M_USER';