Oracle Partition Small Instance

--Grade ranking table
drop table Graderecord
CREATE TABLE Graderecord (
Sno VARCHAR2 (10),
Sname varchar2 (20),
Dormitory VARCHAR2 (5),
Grade int
)
Partition by range (grade) (
Partition Bujige values less than (60),
Partition Jige values less than (85),
Partition Youxiu values less than (MaxValue)

);
Select *from Graderecord;
INSERT into Graderecord values (' 1001 ', ' Liu ', ' 202 ', 92);
INSERT into Graderecord values (' 1002 ', ' inside ', ' 2034 ', 52);
INSERT into Graderecord values (' 1003 ', ' Zhang ', ' 20244 ', 41);
INSERT into Graderecord values (' 1004 ', ' Bull ', ' 2025 ', 62);
INSERT into Graderecord values (' 1005 ', ' l ', ' 2026 ', 69);
INSERT into Graderecord values (' 1006 ', ' duration ', ' 2027 ', 73);
INSERT into Graderecord values (' 1007 ', ' personal ', ' 2028 ', 84);
INSERT into Graderecord values (' 1008 ', ' Give him ', ' 2029 ', 85);
INSERT into Graderecord values (' 1009 ', ' hot air ', ' 2072 ', 42);
Select *from Graderecord partition (Bujige);
Select *from Graderecord partition (JIGE);
Select *from Graderecord partition (Youxiu);

Oracle Partition Small Instance