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