ORACLE - PLAN TABLE 생성

CREATE TABLE plan_table (
        STATEMENT_ID       VARCHAR2(30),
        plan_id            NUMBER,
        TIMESTAMP          DATE,
        remarks            VARCHAR2(4000),
        operation          VARCHAR2(30),
        options            VARCHAR2(255),
        object_node        VARCHAR2(128),
        object_owner       VARCHAR2(30),
        object_name        VARCHAR2(30),
        object_alias       VARCHAR2(65),
        object_instance    NUMERIC,
        object_type        VARCHAR2(30),
        optimizer          VARCHAR2(255),
        search_columns     NUMBER,
        ID                 NUMERIC,
        parent_id          NUMERIC,
        DEPTH              NUMERIC,
        POSITION           NUMERIC,
        COST               NUMERIC,
        CARDINALITY        NUMERIC,
        BYTES              NUMERIC,
        other_tag          VARCHAR2(255),
        partition_start    VARCHAR2(255),
        partition_stop     VARCHAR2(255),
        partition_id       NUMERIC,
        other              LONG,
        distribution       VARCHAR2(30),
        cpu_cost           NUMERIC,
        io_cost            NUMERIC,
        temp_space         NUMERIC,
        access_predicates  VARCHAR2(4000),
        filter_predicates  VARCHAR2(4000),
        projection         VARCHAR2(4000),
        TIME               NUMERIC,
        qblock_name        VARCHAR2(30)
);