SQL Statements and Extensions for the Salesforce Driver : Create Sequence : Next Value For Clause

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

© 2013 Progress Software Corporation and/or its subsidiaries or affiliates.