skip to main content
Reference : Supported SQL Statements and Extensions : Create Sequence : Next Value For Clause
  

Try DataDirect Drivers Now
Next Value For Clause

Purpose

Use the Next Value For clause to specify the next value for a sequence that is used in a Select, Insert, or Update statement.

Syntax

NEXT VALUE FOR sequence_name
where:
sequence_name
specifies the name of the sequence from which to retrieve the value.

Example

The following example retrieves the next value or set of values in Sequence1:
SELECT NEXT VALUE FOR Sequence1 FROM Account