CREATE TABLE sales ( dept_no number, part_no varchar2, country varchar2(20), date date, amount number ) PARTITION BY RANGE(date) SUBPARTITION BY LIST(country) ( PARTITION q1_2012 VALUES LESS ...
/edb-docs/d/edb-postgres-advanced-server/user-guides/database-compatibility-table-partitioning-guide/13/example_adding_a_partition_with_subpartitions_number.html ...