oracle查询自动生成实体entity

select 'private ' || (case
         when col.DATA_TYPE = 'VARCHAR2' then
          'String'
         when col.DATA_TYPE = 'NUMBER' then
          'BigDecimal'
         when col.DATA_TYPE = 'DATE' then
          'Date'
       end) DATA_TYPE1
      ,LOWER(substr(REPLACE(INITCAP(col.COLUMN_NAME), '_', ''), 1, 1)) ||
       substr(REPLACE(INITCAP(col.COLUMN_NAME), '_', ''), 2)
      ,LOWER(substr(REPLACE(INITCAP(col.COLUMN_NAME), '_', ''), 1, 1)) ||
       substr(REPLACE(INITCAP(col.COLUMN_NAME), '_', ''), 2) || ';'
      ,'dto.set' || REPLACE(INITCAP(col.COLUMN_NAME), '_', '') || '(xxx);'
      ,'dto.get' || REPLACE(INITCAP(col.COLUMN_NAME), '_', '') || '()'
      ,'dto.set' || REPLACE(INITCAP(col.COLUMN_NAME), '_', '') || '(' ||
       'rs.get' || (case
         when col.DATA_TYPE = 'VARCHAR2' then
          'String'
         when col.DATA_TYPE = 'NUMBER' then
          'BigDecimal'
         when col.DATA_TYPE = 'DATE' then
          'Date'
       end) || '("' ||
       LOWER(substr(REPLACE(INITCAP(col.COLUMN_NAME), '_', ''), 1, 1)) ||
       substr(REPLACE(INITCAP(col.COLUMN_NAME), '_', ''), 2) || '")' || ');'
      ,CONCAT('//', com.comments)
  from user_tab_columns col
inner join user_col_comments com
    on col.TABLE_NAME = UPPER('SCORE_MERGE_SETTING')
   and col.TABLE_NAME = com.TABLE_NAME
   and col.COLUMN_NAME = com.COLUMN_NAME
order by col.COLUMN_ID;