코드조각

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