ORACLE 간편 코드 조각 모음

COMMENT 생성 코드 조각

COMMENT ON COLUMN MEMBER.MEM_ID IS '아이디'; 
 SELECT 'COMMENT ON COLUMN '|| TABLE_NAME ||'.' ||COLUMN_NAME || ' IS '''';'     
   FROM COLS 
  WHERE TABLE_NAME = 'MEMBER' 
  ORDER BY COLUMN_ID;

VO 생성 코드 조각

SELECT CASE WHEN NULLABLE='N' AND (DATA_TYPE='VARCHAR2' OR DATA_TYPE='CHAR')
       THEN '@NotBlank'
       WHEN NULLABLE='N' AND DATA_TYPE = 'NUMBER' THEN '@NotNull @Min(0)'
       ELSE '' END
      || DECODE(DATA_TYPE, 'NUMBER', '', '@Size(max='||DATA_LENGTH||')')     
      ||  ' private '||
      DECODE( DATA_TYPE , 'NUMBER', 'Integer ', 'String ' )||
      LOWER(COLUMN_NAME)||';'
 FROM COLS
WHERE TABLE_NAME = 'PROD'
ORDER BY COLUMN_ID;