Oracle range分区values less than代表的是小于

1.对于日期date测试验证

CREATE TABLE t (
  id NUMBER,
  d1 DATE,
  n1 NUMBER,
  n2 NUMBER,
  n3 NUMBER,
  pad VARCHAR2(4000),
  CONSTRAINT t_pk PRIMARY KEY (id)
)
PARTITION BY RANGE (n1, d1) (
  PARTITION t_1_jan_2007 VALUES LESS THAN (1, to_date('2007-02-01','yyyy-mm-dd')),
  PARTITION t_1_feb_2007 VALUES LESS THAN (1, to_date('2007-03-01','yyyy-mm-dd')),
  PARTITION t_1_mar_2007 VALUES LESS THAN (1, to_date('2007-04-01','yyyy-mm-dd')),
  PARTITION t_1_apr_2007 VALUES LESS THAN (1, to_date('2007-05-01','yyyy-mm-dd')),
  PARTITION t_1_may_2007 VALUES LESS THAN (1, to_date('2007-06-01','yyyy-mm-dd')),
  PARTITION t_1_jun_2007 VALUES LESS THAN (1, to_date('2007-07-01','yyyy-mm-dd')),
  PARTITION t_1_jul_2007 VALUES LESS THAN (1, to_date('2007-08-01','yyyy-mm-dd')) );




第一个分区t_1_jan_2007 包含了N1等于1的数字，但是不包含2007-02-01的内容。
第二个分区才包含了2007-02-01的内容

2.对于数字number测试验证

CREATE TABLE a (ID NUMBER)
  2  PARTITION BY RANGE(ID)
  3  (
  4  PARTITION P_01 VALUES LESS THAN (3),
  5  PARTITION P_02 VALUES LESS THAN (10),
  6  PARTITION P_03 VALUES LESS THAN (Maxvalue));

Table created.

SQL> INSERT INTO a
  2  SELECT 3 FROM dual;

1 row created.

SQL> INSERT INTO a
  2  SELECT 10 FROM dual;

1 row created.

SQL> COMMIT;

Commit complete.

SQL> SELECT * FROM a PARTITION (P_01);

no rows selected

SQL> SELECT * FROM a PARTITION (P_02);

        ID
----------
         3

SQL> SELECT * FROM a PARTITION (P_03);

        ID
----------
        10