sqldeveloper 이용한 vo sql

SELECT 
    ' private '||
   DECODE( DATA_TYPE , 'NUMBER', 'int ', 'String ' )||
    LOWER(COLUMN_NAME)||';'
FROM COLS
WHERE TABLE_NAME = '테이블명(대문자)'
ORDER BY COLUMN_ID;

예시)

SELECT 
    ' private '||
   DECODE( DATA_TYPE , 'NUMBER', 'int ', 'String ' )||
    LOWER(COLUMN_NAME)||';'
FROM COLS
WHERE TABLE_NAME = 'JDBC_BOARD'
ORDER BY COLUMN_ID;