List partitioning
From Oracle FAQ
List partitioning is a partitioning technique where you specify a list of discrete values for the partitioning key in the description for each partition.
History[edit]
List partitioning was introduced with Oracle 9i.
Example[edit]
CREATE TABLE myemp_work ( emp# NUMBER PRIMARY KEY, ename VARCHAR2(30), salary NUMBER(8,2), deptno NUMBER) PARTITION BY LIST (deptno) ( PARTITION p10 VALUES (10), PARTITION p20 VALUES (20), PARTITION p30 VALUES (30,40), PARTITION p40 VALUES (DEFAULT));