VLDB large database partition table list Partition Table details

VLDB large database partition table list Partition Table detailed list partition list partitions explicitly specify partitions based on a specific value of a field, rather than partitions based on the value range of the field as the range partition. SQL code: create table graderecord03 (sno varchar2 (10), sname varchar2 (20), dormitory varchar2 (3), grade int) partition by list (dormitory) (partition d229 values ('20170101') tablespace test01, partition d228 values ('20170101') tablespace test02, partition d240 values ('20170101') tablespace test03) the preceding table partitions are performed based on the dormitory, and the same data as the range partition experiment is inserted and queried as follows: SQL code: Insert into graderecord03 values ('20170101', 'ku ', '20140901', 92); insert into graderec Ord03 values ('20170101', 'OK', '20160301', 62); insert into graderecord03 values ('20160301', 'east', '20160302', 26 ); insert into graderecord03 values ('20140901', 'liang', '20160901', 77); insert into graderecord03 values ('20160901', 'jing', '20160301', 47 ); insert into graderecord03 (sno, sname, dormitory) values ('000000', 'feng', '000000'); insert into graderecord03 values ('20140901', 'ming ', '20140901', 90); insert into graderecord03 values ('20160901', 'nan', '20160901', 240); insert in To graderecord03 values ('20160301', 'Tao', '20160301', 67); insert into graderecord03 values ('20160301', 'bo', '20160301', 75 ); insert into graderecord03 values ('20140901', '20160901', 60); select * from graderecord03; select * from graderecord03 partition (d229 ); select * from graderecord03 partition (d228); select * from graderecord03 partition (d240); d229 partition data: SQL> select * from graderecord03; SNO SNAME DOR GRADE ---------- -------------------- --- ---------- 511601 ??? 229 92511602 ??? 229 62511603 ??? 229 26511601 ??? 229 92511602 ??? 229 62511603 ??? 229 26511604 ??? 228 77511605 ??? 228 47511606 ??? 228511604 ??? 228 77511605 ??? 228 47SNO sname dor grade ---------- ------------------ --- ---------- 511606 ??? 228511607 ??? 240 90511608 ??? 240 100511609 ??? 240 67511610 ??? 240 75511611 ??? 240 60511607 ??? 240 90511608 ??? 240 100511609 ??? 240 67511610 ??? 240 75511611 ??? 240 6022 rows selected. SQL> select * from graderecord03 partition (d229); SNO SNAME DOR GRADE ---------- -------------------- --- ---------- 511601 ??? 229 92511602 ??? 229 62511603 ??? 229 26511601 ??? 229 92511602 ??? 229 62511603 ??? 229 266 rows selected. SQL> select * from graderecord03 partition (d228); SNO SNAME DOR GRADE ---------- -------------------- --- ---------- 511604 ??? 228 77511605 ??? 228 47511606 ??? 228511604 ??? 228 77511605 ??? 228 47511606 ??? 2286 rows selected. SQL> select * from graderecord03 partition (d240); SNO SNAME DOR GRADE ---------- -------------------- --- ---------- 511607 ??? 240 90511608 ??? 240 100511609 ??? 240 67511610 ??? 240 75511611 ??? 240 60511607 ??? 240 90511608 ??? 240 100511609 ??? 240 67511610 ??? 240 75511611 ??? 240 6010 rows selected. SQL>