VO 카멜 케이스

★ 카멜케이스 코드조각 : 아직 vo 없는 부분도 있어서 나중에 필요할때쓰세요

-- 카멜케이스
select CASE WHEN A.NULLABLE='N' AND (DATA_TYPE='VARCHAR2' OR DATA_TYPE='CHAR')
        THEN '@NotBlank'
        WHEN A.NULLABLE='N' AND DATA_TYPE = 'NUMBER' THEN '@NotNull @Min(0)'
        ELSE '' END
   || DECODE(A.DATA_TYPE, 'NUMBER', '', '@Size(max='||DATA_LENGTH||')')     
   ||  ' private '||
   DECODE(A.DATA_TYPE , 'NUMBER', 'Integer ', 'String ' )||
   LOWER(SUBSTR(  REPLACE(initcap(A.COLUMN_NAME),'_'),1,1))||
   SUBSTR(  REPLACE(initcap(A.COLUMN_NAME),'_'),2)||
   '; //'||B.COMMENTS
from cols A INNER JOIN USER_COL_COMMENTS B ON (A.TABLE_NAME = B.TABLE_NAME)
WHERE A.TABLE_NAME = 'MAINTENANCECOST'
  AND A.COLUMN_NAME = B.COLUMN_NAME
ORDER BY COLUMN_ID;
desc service;