Explanation/Reference:
Explanation:
- an application can obtain the next sequence number without inserting the row by calling the NEXT
VALUE FOR function.
- ALTER SEQUENCE Includes argument:
RESTART [ WITH <constant> ]
The next value that will be returned by the sequence object. If provided, the RESTART WITH value must
be an integer that is less than or equal to the maximum and greater than or equal to the minimum value of
the sequence object. If the WITH value is omitted, the sequence numbering restarts based on the original
CREATE SEQUENCE options.
- CREATE SEQUENCE
Creates a sequence object and specifies its properties. A sequence is a user-defined schema bound
object that generates a sequence of numeric values according to the specification with which the sequence
was created. The sequence of numeric values is generated in an ascending or descending order at a
defined interval and can be configured to restart (cycle) when exhausted.