04 2 create table02.sql

--デフォルト値にシーケンスを使用する
CREATE TABLE TABLE2
(
    ID          NUMBER(10,0) DEFAULT MY_SEQUENCE_01.nextval NOT NULL
   ,COLUMN1     VARCHAR2(50)
   ,COLUMN2     VARCHAR2(50)
   ,COLUMN3     VARCHAR2(50)
   ,COLUMN4     VARCHAR2(50)
   ,COLUMN5     VARCHAR2(50)
   ,COLUMN6     VARCHAR2(50)
   ,DATE1       DATE                            default SYSDATE
   ,TIMESTAMP1  TIMESTAMP                       default SYSTIMESTAMP
   ,TIMESTAMP2  TIMESTAMP WITH TIME ZONE        default SYSTIMESTAMP
   ,TIMESTAMP3  TIMESTAMP WITH LOCAL TIME ZONE  default SYSTIMESTAMP
   ,CONSTRAINT TABLE2_PK PRIMARY KEY (ID) USING INDEX
        PCTFREE 10
        INITRANS 2
        MAXTRANS 255
        --TABLESPACE KAKIP2
        STORAGE(INITIAL 64K MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT)
        LOGGING
)
PCTFREE 5
MAXTRANS 255
--TABLESPACE KAKIP2
STORAGE(INITIAL 6M MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT)
NOCACHE
LOGGING;
COMMENT ON TABLE TABLE2 IS 'TABLE2';
COMMENT ON COLUMN TABLE2.COLUMN1     IS 'COLUMN1';
COMMENT ON COLUMN TABLE2.COLUMN2     IS 'COLUMN2';
COMMENT ON COLUMN TABLE2.COLUMN3     IS 'COLUMN3';
COMMENT ON COLUMN TABLE2.COLUMN4     IS 'COLUMN4';
COMMENT ON COLUMN TABLE2.COLUMN5     IS 'COLUMN5';
COMMENT ON COLUMN TABLE2.DATE1       IS 'DATE1';
COMMENT ON COLUMN TABLE2.TIMESTAMP1  IS 'TIMESTAMP1';
COMMENT ON COLUMN TABLE2.TIMESTAMP2  IS 'TIMESTAMP2';
COMMENT ON COLUMN TABLE2.TIMESTAMP3  IS 'TIMESTAMP3';