会：
例：

-- 数据准备：
CREATE TABLE t1
 (
 id number,
 CD NUMBER (8) NOT NULL
) PARTITION BY RANGE(CD)(
 PARTITION t1_RANGE_10 VALUES LESS THAN (10),
 PARTITION t1_RANGE_20 VALUES LESS THAN (20),
 PARTITION t1_RANGE_30 VALUES LESS THAN (30)
    );
insert into t1 values(1,5);
insert into t1 values(2,15);
insert into t1 values(3,25);
select * from t1 partition(t1_RANGE_10);
select * from t1 partition(t1_RANGE_20);
select * from t1 partition(t1_RANGE_30);
SQL> select * from t1 partition(t1_RANGE_10);

        ID         CD
---------- ----------
         1          5

SQL> select * from t1 partition(t1_RANGE_20);

        ID         CD
---------- ----------
         2         15

SQL> select * from t1 partition(t1_RANGE_30);

        ID         CD
---------- ----------
         3         25
复制

若对答案满意，请点击采纳按钮哦！