SELECT 'private ' 
        || DECODE(B.DATA_TYPE, 'NUMBER', 'int ', 'String ')
        || LOWER(B.COLUMN_NAME)
        || ' = '
        || DECODE(B.DATA_TYPE, 'NUMBER', '0', '""')
        ||'; //'||C.COMMENTS
  FROM USER_TABLES A
     , USER_TAB_COLUMNS B
     , USER_COL_COMMENTS C
 WHERE A.TABLE_NAME = B.TABLE_NAME
   AND B.COLUMN_NAME = C.COLUMN_NAME
   AND B.TABLE_NAME = C.TABLE_NAME
   AND A.TABLE_NAME = 'COMTCCMMNCODE'
 ORDER BY B.COLUMN_ID
;

조회 쿼리


private String code_id = ""; //

private String code_id_nm = ""; //

private String code_id_dc = ""; //

private String use_at = ""; //

private String cl_code = ""; //

private String frst_regist_pnttm = ""; //

private String frst_register_id = ""; //

private String last_updt_pnttm = ""; //

private String last_updusr_id = ""; //

조회 결과


VO 클래스에 넣고 getter, setter 생성하고 커스트마이징하고.