as-subquery-clause:

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 )
3.0 WITH NO DATA
3.0 WITH DATA
3.1? copy-options
3 refreshable-table-options

copy-options:

1.0 EXCLUDING IDENTITY
1.0.1! COLUMN ATTRIBUTES
1.0 INCLUDING IDENTITY
1.0.1! COLUMN ATTRIBUTES
1.1 EXCLUDING
1.1.1! COLUMN
1.1.2 DEFAULTS
1.1 INCLUDING
1.1.1! COLUMN
1.1.2 DEFAULTS
1.1 USING TYPE DEFAULTS
1.2 (1) 


refreshable-table-options:

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