Oracle建表、设置主键、建立分区、添加索引、添加备注语法

CREATE TABLE t_test(
   pk_id NUMBER(30) NOT NULL,
   add_date_time DATE,
   CONSTRAINT PK_T_TEST PRIMARY KEY(pk_id)  --设置主键
)

--建立分区
PARTITION BY RANGE(add_date_time)
(
   PARTITION t_test_2013_less VALUES LESS THAN (to_date('2013-01-01 00:00:00','yyyy-mm-ddhh24:mi:ss')),
   PARTITION t_test_2013 VALUES LESS THAN (to_date('2014-01-01 00:00:00','yyyy-mm-ddhh24:mi:ss')),
   PARTITION t_test_2014 VALUES LESS THAN (to_date('2015-01-01 00:00:00','yyyy-mm-dd hh24:mi:ss'))
);

--添加索引
CREATE INDEX idx_id_date_tm ON t_test(pk_id,add_date_time);

--添加备注
COMMENT ON TABLE t_test IS '测试表';
COMMENT ON COLUMN t_test.pk_id IS '主键ID';
COMMENT ON COLUMN t_test.add_date_time IS '增量时间';