| 123456789101112131415161718192021222324 |
- 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
|
