|
Syntax
$SEQUENCE(sequence_name [, options])
sequence_name
sequence_name is the name of a sequence created using the
CREATE SEQUENCE statement.
options
options is a character string determining the action to take
against sequence_name
CURRENT return the
current value of sequence_name
NEXT increment the
value of sequence_name after returning the value.
PREVIOUS decrement
the value of sequence_name after returning the value.
top
Example
SELECT $SEQUENCE(‘products_sequence’,
‘next’) …
top
|
