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

materialized-query-definition

1? (
1.1 column-name
1.1.1? FOR
1.1.1.1! COLUMN
1.1.1.2 system-column-name
1.1.1.3 )
2 AS ( select-statement ) refreshable-table-options

refreshable-table-options

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