oracle分表sql,Oracle数据库 表分区

Oracle表分区分为四种：范围分区，散列分区，列表分区和复合分区。

一：范围分区

Sql代码

create table graderecord

(

sno varchar2(10),

sname varchar2(20),

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 graderecord values('511601','魁','229',92);

insert into graderecord values('511602','凯','229',62);

insert into graderecord values('511603','东','229',26);

insert into graderecord values('511604','亮','228',77);

insert into graderecord values('511605','敬','228',47);

insert into graderecord(sno,sname,dormitory) values('511606','峰','228');

insert into graderecord values('511607','明','240',90);

insert into graderecord values('511608','楠','240',100);

insert into graderecord values('511609','涛','240',67);

insert into graderecord values('511610','博','240',75);

insert into graderecord values('511611','铮','240',60);

下面查询一下全部数据，然后查询各个分区数据，代码一起写：

select * from graderecord;

select * from graderecord partition(bujige);

select * from graderecord partition(jige);

select * from graderecord partition(youxiu);

全部数据如下：

不及格数据如下：