The following table explains the meanings of the expand interval syntax variables for the EXPAND ON clause.
| Expand Interval | Description |
|---|---|
| interval_literal | To perform an interval expansion, specify any valid Interval literal value (see Interval Literals for a comprehensive list of valid Interval literals). |
| ANCHOR anchor_name | To perform an anchor point expansion, specify an anchor name, but do not specify PERIOD. |
| ANCHOR PERIOD anchor_name | To perform an anchor period expansion, you must specify PERIOD and an anchor name. |