DDL

/* 테이블 추가 */

CREATE TABLE [TableName\]

(

    [ColumnName] [ColumnType] [NOT NULL / NULL],

    REGI\_ID VARCHAR2(20 BYTE) NULL,  
    RGST\_DT DATE NULL,  
    AMEN\_ID VARCHAR2(20 BYTE) NULL,  
    UPDT\_DT DATE NULL

);

COMMENT ON TABLE [TableName] IS '테이블명';

COMMENT ON COLUMN [TableName].[ColumnName] IS '칼럼명';

ALTER TABLE [TableName] ADD

(

    CONSTRAINT [PK_TableName]

    PRIMARY KEY ( [PK ColumnName] )

        USING INDEX

);

/* 칼럼 추가 */

ALTER TABLE [TableName] ADD ([ColumnName] [ColumnType]);  
COMMENT ON COLUMN [TableName].[ColumnName] IS '[Comment]';

/* 칼럼명 변경 */
ALTER TABLE [TableName] RENAME COLUMN [변경전ColumnName] TO [변경후ColumnName];