分区表-脚本

------指定具体值------------
create table grade_record
  (
  sno varchar2(10),
  dormitory varchar2(3),
  grade int
)
partition by list(grade)
(
  partition bujige values (60), --不及格
  partition jige values (85), --及格
  partition youxiu values (100) --优秀
);


---------------

create table recordgrade
  (
  sno varchar2(10),
  dormitory varchar2(3),
  grade int
)
partition by range(grade)
(
  partition bujige values less than(60), --不及格
  partition jige values less than(85), --及格
  partition youxiu values less than(maxvalue) --优秀
);

insert into recordgrade values('511601','229',92);
insert into recordgrade values('511602','229',62);
insert into recordgrade values('511603','229',26);
insert into recordgrade values('511604','228',77);
insert into recordgrade values('511605','228',47);
insert into recordgrade(sno,dormitory) values('511606','228');
insert into recordgrade values('511607','240',90);
insert into recordgrade values('511608','240',100);
insert into recordgrade values('511609','240',67);
insert into recordgrade values('511610','240',75);
insert into recordgrade values('511611','240',60);
commit;

select * from recordgrade order by grade;                  
select * from recordgrade partition(bujige)order by grade;
select * from recordgrade partition(jige)order by grade;  
select * from recordgrade partition(youxiu)order by grade;

说明：数据中有空值，Oracle机制会自动将其规划到maxvalue的分区中。