코멘트 생성

테이블

SELECT    'ALTER TABLE ' || TABLE_NAME || ' ADD (INP_ID VARCHAR2(30));' || CHR (13)
       || 'ALTER TABLE ' || TABLE_NAME || ' ADD (INP_DT DATE);' || CHR (13)
       || 'ALTER TABLE ' || TABLE_NAME || ' ADD (INP_IP VARCHAR2(50));' || CHR (13)
       || 'ALTER TABLE ' || TABLE_NAME || ' ADD (UPD_ID VARCHAR2(30));' || CHR (13)
       || 'ALTER TABLE ' || TABLE_NAME || ' ADD (UPD_DT DATE);' || CHR (13)
       || 'ALTER TABLE ' || TABLE_NAME || ' ADD (UPD_IP VARCHAR2(50));' || CHR (13)
FROM   all_tables
WHERE  OWNER = 'CKU_STD'

컬럼

SELECT    'COMMENT ON COLUMN ' || TABLE_NAME || '.INP_ID IS ''생성자'';' || CHR(13)
       || 'COMMENT ON COLUMN ' || TABLE_NAME || '.INP_DT IS ''생성일시'';' || CHR(13)
	   || 'COMMENT ON COLUMN ' || TABLE_NAME || '.INP_IP IS ''생성IP'';' || CHR(13)
	   || 'COMMENT ON COLUMN ' || TABLE_NAME || '.UPD_ID IS ''수정자'';' || CHR(13)
	   || 'COMMENT ON COLUMN ' || TABLE_NAME || '.UPD_DT IS ''수정일시'';' || CHR(13)
	   || 'COMMENT ON COLUMN ' || TABLE_NAME || '.UPD_IP IS ''수정IP'';' || CHR(13)
FROM   all_tables
WHERE  OWNER = 'CKU_STD'