Specifies a minimum value of 1 for an ascending sequence or –2147483647 for a descending sequence. This integer value can have 10 or fewer digits. Specifies the minimum value that the sequence can generate. Specifies a maximum value of 2147483647 for an ascending sequence or –1 for a descending sequence. Specifies the maximum value the sequence can generate. If you omit the INCREMENT BY clause, the default is 1. The absolute of this value must be less than the difference of MAXVALUE and MINVALUE. Can be any positive or negative integer, but cannot be 0. Specifies the interval between sequence numbers. If you omit schema, Oracle Database Lite alters the sequence in your own schema. The name of the schema to contain the sequence. Table 4-6 Arguments Used with the ALTER SEQUENCE Command Argument The bracketed appearance of the term begins with a comma if the repetitions are comma delimited.Īll other punctuation (quotation marks, commas, semicolons, and so on) must be typed as shown. The ellipsis points indicate that multiple repetitions are allowed.

The brackets indicate that the repetition is optional (all repetitions are optional).

Loops or repetitions are indicated by a second, bracketed appearance of the term, set of terms, or expression, followed by ellipsis points. (The choices are separated by vertical bars.) They indicate that you must specify one of the enclosed choices. They indicate that the enclosed syntax is optional.Ĭurly braces ( ) usually are not typed. Parentheses and other punctuation enclosed in quotes must be typed as shown, for example '('. Vertical (|) bars separate multiple choices. These can include clauses and other expressions. Placeholders for which you must substitute an actual value are shown in lowercase.

Emphasis and symbols have the following meaning in this version of BNF syntax. The syntax diagrams in this document use a variation of Backus-Nauer Form (BNF), a convention used to show syntax in many programming languages.

Dbschema no more spool space