Oracle DTO 만들기2 - number(int, double형 추가)

SELECT '@Schema(description = "'
              ||REPLACE( b.comments, CHR( 10 ), '' )
              ||'")'
              ||CHR( 10 )
              || 'private '
              ||
       CASE
              WHEN A.DATA_TYPE = 'NUMBER'
              THEN
                     CASE
                            WHEN NVL( data_scale, 0 ) = 0
                            THEN 'int '
                            ELSE 'double '
                     END
              ELSE 'String '
       END
       --|| DECODE( a.data_type, 'NUMBER'
       --        , 'int '
       --        , 'String ' )
       --|| 'srch'||SUBSTR( upper( a.column_name ), 1, 1 )
              || SUBSTR( lower( a.column_name ), 1, 1 )
              ||SUBSTR( REPLACE( INITCAP( a.column_name ), '_', '' ), 2 )
              ||';'
  FROM user_tab_cols a
     , user_col_comments b
 WHERE a.table_name  = b.table_name
   AND a.column_name = b.column_name
   AND a.table_name  = UPPER( :TABLENAME );