ending-clause

1 ENDING
2! AT
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

hash-partition-spec

1 (
2+ ,
2 column-name
3 ) INTO integer PARTITIONS

add-partition

1? partition-name
1.1 boundary-spec
1.2? media-preference
1 integer
1.1 HASH PARTITIONS
1.1 HASH PARTITION

materialized-query-definition

1 ( select-statement ) refreshable-table-options

refreshable-table-options

1 DATA INITIALLY DEFERRED
1 DATA INITIALLY IMMEDIATE
2 REFRESH DEFERRED
3+ 
3 MAINTAINED BY USER
3 ENABLE QUERY OPTIMIZATION
3 DISABLE QUERY OPTIMIZATION
4 (1) 


materialized-query-table-alteration

1 ( select-statement )
1.1? refreshable-table-options
1 SET
1.1.0+ 
1.1.0 REFRESH DEFERRED
1.1.0 MAINTAINED BY USER
1.1.0 ENABLE QUERY OPTIMIZATION
1.1.0 DISABLE QUERY OPTIMIZATION
1.1.1 (2)