DataTable 칼럼 생성 쿼리

---

우리 회사용

---

WITH VMAIN AS
(
SELECT 'dtList' AS tableName FROM DUAL
)       
 SELECT '            DevExpHelper.addColumn(' || VMAIN.tableName || ', "' 
  || LOWER(SUBSTR(REPLACE(INITCAP(REPLACE(MCOLS.COLUMN_NAME, '_', ' ')), ' ', ''), 1, 1)) || SUBSTR(REPLACE(INITCAP(REPLACE(MCOLS.COLUMN_NAME, '_', ' ')), ' ', ''), 2) 
      || '", "' || CCOLS.COMMENTS || '");'
  FROM VMAIN
     , USER_TAB_COLUMNS MCOLS
     , USER_COL_COMMENTS CCOLS
 WHERE MCOLS.TABLE_NAME = CCOLS.TABLE_NAME (+)
   AND MCOLS.COLUMN_NAME = CCOLS.COLUMN_NAME (+)
   AND MCOLS.TABLE_NAME = 'ETI_EQPMDLBRBRKD'
 ORDER BY
       MCOLS.COLUMN_ID;

---

            DevExpHelper.addColumn(dtList, "dlbrSqno", "심의순번");
            DevExpHelper.addColumn(dtList, "dlbrPid", "심의등록번호");
            DevExpHelper.addColumn(dtList, "dlbrAplcStatCd", "심의신청상태코드");

---

WITH VMAIN AS
(
SELECT 'gvList' AS gridName FROM DUAL
)       
 SELECT '            this.' || gridName || '.setColumnEdit("'  
 			|| LOWER(SUBSTR(REPLACE(INITCAP(REPLACE(MCOLS.COLUMN_NAME, '_', ' ')), ' ', ''), 1, 1)) || SUBSTR(REPLACE(INITCAP(REPLACE(MCOLS.COLUMN_NAME, '_', ' ')), ' ', ''), 2) 
      || '", DevExpHelper.getRiTextLeft(), false);	/* '
      || CCOLS.COMMENTS || ' */'
  FROM VMAIN
     , USER_TAB_COLUMNS MCOLS
     , USER_COL_COMMENTS CCOLS
 WHERE MCOLS.TABLE_NAME = CCOLS.TABLE_NAME (+)
   AND MCOLS.COLUMN_NAME = CCOLS.COLUMN_NAME (+)
   AND MCOLS.TABLE_NAME = 'ETI_EQPMDLBRBRKD'
 ORDER BY
       MCOLS.COLUMN_ID;

---

            this.gvList.setColumnEdit("dlbrSqno", DevExpHelper.getRiTextLeft(), false);	/* 심의순번 */
            this.gvList.setColumnEdit("dlbrPid", DevExpHelper.getRiTextLeft(), false);	/* 심의등록번호 */

---

WITH VMAIN AS
(
SELECT 'gvList' AS gridName FROM DUAL
)       
 SELECT '            this.' || gridName || '.Columns["'  
 			|| LOWER(SUBSTR(REPLACE(INITCAP(REPLACE(MCOLS.COLUMN_NAME, '_', ' ')), ' ', ''), 1, 1)) || SUBSTR(REPLACE(INITCAP(REPLACE(MCOLS.COLUMN_NAME, '_', ' ')), ' ', ''), 2) 
      || '"].Visible = false;	/* '
      || CCOLS.COMMENTS || ' */'
  FROM VMAIN
     , USER_TAB_COLUMNS MCOLS
     , USER_COL_COMMENTS CCOLS
 WHERE MCOLS.TABLE_NAME = CCOLS.TABLE_NAME (+)
   AND MCOLS.COLUMN_NAME = CCOLS.COLUMN_NAME (+)
   AND MCOLS.TABLE_NAME = 'ETI_EQPMDLBRBRKD'
 ORDER BY
       MCOLS.COLUMN_ID;

---

            this.gvList.Columns["dlbrSqno"].Visible = false;	/* 심의순번 */
            this.gvList.Columns["dlbrPid"].Visible = false;	/* 심의등록번호 */