partitioning-clause 1 PARTITION BY 2! RANGE 2.1 range-partition-spec 2 HASH hash-partition-spec range-partition-spec 1 ( 2+ , 2 partition-expression 3 ) ( 4+ , 4 partition-element 5 ) partition-expression 1 column-name 2! NULLS LAST 2? 2 NULLS FIRST partition-element 1.0? PARTITION partition-name 1.1 boundary-spec 1.2? media-preference 1 boundary-spec EVERY ( integer-constant 1.1? 1.1 DAY 1.1 DAYS 1.1 MONTH 1.1 MONTHS 1.1 YEAR 1.1 YEARS 1.2 ) (1) boundary-spec 1? starting-clause 2? ending-clause starting-clause 1 STARTING 2! FROM 3 ( 3.1+ , 3.1.0 constant 3.1.0 MINVALUE 3.1.0 MAXVALUE 3.2 ) 3 constant 3 MINVALUE 3 MAXVALUE 4! INCLUSIVE 4? 4 EXCLUSIVE