Oracle 공용 로그 필드 추가
코멘트 생성
테이블
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'
최신 댓글