oracle查询生成列别名

select ','
      ,col.COLUMN_NAME
      ,' as '
      ,LOWER(substr(REPLACE(INITCAP(col.COLUMN_NAME), '_', ''), 1, 1)) ||
       substr(REPLACE(INITCAP(col.COLUMN_NAME), '_', ''), 2)
  from user_tab_columns col
inner join user_col_comments com
    on col.TABLE_NAME = UPPER('OFFENSE_TYPE')
   and col.TABLE_NAME = com.TABLE_NAME
   and col.COLUMN_NAME = com.COLUMN_NAME
order by col.COLUMN_ID;