The CURRENT_VALUE Function
Syntax for the CURRENT_VALUE function:
- The result is the current value of the sequence specified in sequence_name. This is the value that was returned when the NEXT_VALUE function was used for this sequence in this session.
- This function cannot be used until the initial value has been established for the sequence by using NEXT_VALUE (i.e. using it immediately after the sequence has been created will raise an error).
- The function can be used where a value-expression would normally be used. It can also be used after the DEFAULT clause in the CREATE DOMAIN, CREATE TABLE and ALTER TABLE statements.
- USAGE privilege must be held on the sequence in order to use it.
Upright Database Technology AB
Voice: +46 18 780 92 00
Fax: +46 18 780 92 40