Oracle 脚本生成实体

非常好用的Oracle 脚本生成实体。话不多说，直接上脚本。

select rownum as ord,val from (select '@Column(name = "'||a.COLUMN_NAME||'", table = "'||a.TABLE_NAME||'")' as val
  from user_col_comments a,user_tab_columns b
where a.TABLE_NAME = 'WEBED01'
  and a.TABLE_NAME = b.TABLE_NAME
  and a.COLUMN_NAME = b.COLUMN_NAME
  ORDER BY TO_NUMBER(B.COLUMN_ID) ASC)
union
select rownum as ord,val from (select 'private '||case when b.DATA_TYPE='NUMBER' then 'BigDecimal' when b.DATA_TYPE='DATE' then 'Date' else 'String' end||' '||lower(a.COLUMN_NAME)||'; //'||a.COMMENTS as val
  from user_col_comments a,user_tab_columns b
where a.TABLE_NAME = 'WEBED01'
  and a.TABLE_NAME = b.TABLE_NAME
  and a.COLUMN_NAME = b.COLUMN_NAME
  ORDER BY TO_NUMBER(B.COLUMN_ID) ASC); 

 

灵活修改 ，执行后copy就可以啦