select column_name||',' from user_tab_cols a where a.table_name = 'SEL_FUND_CUST_ACCOUNT' order by a.column_id asc select 'public static class' || ' SLM_BASE_CUSTOMER' || '{ ' from dual union all select * from (select ' public static string ' || a.COLUMN_NAME || ' = ' || '"' || a.COLUMN_NAME || '"' || ';' from user_tab_columns a where a.TABLE_NAME = 'SLM_BASE_CUSTOMER' order by a.COLUMN_ID) union all select ' }' from dual select lower(case when a.DATA_TYPE like '%DATE%' then 'to_char('||a.COLUMN_NAME||','||''''||'{1}'||'''' ||') '||COLUMN_NAME else a.COLUMN_NAME end) ||',' from user_tab_columns a where a.TABLE_NAME = 'SLM_ORDER_LINE' order by a.COLUMN_ID; select 'public static string ' || a.COLUMN_NAME || ' = ' || '"' || a.COLUMN_NAME || '"' || ';' from user_tab_columns a where a.TABLE_NAME = 'SLM_ORDER_LINE' order by a.COLUMN_ID