oracle 根据表名生成实体类（驼峰）

 oracle中可以根据表字段名称和备注生成需要的实体类，可以根据实际情况对该sql进行修改。

--生成实体类
select 
'@PropertyDef(label = "'|| t.COMMENTS ||'")' || chr(13) || 'private ' || 
(case 
  when b.DATA_TYPE = 'VARCHAR2' then 'String'
  when b.DATA_TYPE = 'NUMBER' then 'BigDecimal'
  when b.DATA_TYPE = 'DATE' then 'DATE' 
 else b.DATA_TYPE end)
  ||
replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(
replace(replace(replace(replace(replace(replace(replace(replace(replace(' ' || lower(t.COLUMN_NAME) || ';',
     '_a','A'),'_b','B'), '_c','C'), '_d','D'), '_e','E'),'_f','F'),'_g','G'),'_h','H'),
     '_i', 'I'),'_j', 'J'),'_k', 'K'),'_l', 'L'), '_m','M'),'_n','N'),
     '_o', 'O'),'_p', 'P'),'_q', 'Q'),'_r', 'R'), '_s','S'),'_t','T'),
     '_u', 'U'),'_v', 'V'),'_w', 'W'),'_x', 'X'), '_y','Y'),'_z','Z')
  from user_col_comments t,user_tab_cols b
 where t.table_name = 'PL_GOODS_TRX' 
 and t.COLUMN_NAME = b.COLUMN_NAME 
 and t.TABLE_NAME = b.TABLE_NAME 
 order by b.column_id;

返回结果如下：