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';