[JAVA] Vo 코드조각

SELECT 
    'private ' || 
    DECODE(DATA_TYPE, 'NUMBER', 'int ', 'String ') || 
    LOWER(SUBSTR(REPLACE(INITCAP(REPLACE(LOWER(COLUMN_NAME), '_', ' ')), ' ', ''), 1, 1)) || 
    SUBSTR(REPLACE(INITCAP(REPLACE(LOWER(COLUMN_NAME), '_', ' ')), ' ', ''), 2) || 
    ';'
FROM COLS
WHERE TABLE_NAME = '테이블 이름'
ORDER BY COLUMN_ID;

 

 

 

 private int code;
 private String codeType;
 private String codeName;
 private String codeSmbl;
 private int codeSort;
 private String delYn;