Uses and Restrictions of NEXTVAL and CURRVAL规格严格

Uses and Restrictions of NEXTVAL and CURRVAL
CURRVAL and NEXTVAL can be used in the following places:

VALUES clause of INSERT statements

The SELECT list of a SELECT statement

The SET clause of an UPDATE statement

CURRVAL and NEXTVAL cannot be used in these places:

A subquery

A view query or materialized view query

A SELECT statement with the DISTINCT operator

A SELECT statement with a GROUP BY or ORDER BY clause

A SELECT statement that is combined with another SELECT statement with the UNION, INTERSECT, or MINUS set operator

The WHERE clause of a SELECT statement

DEFAULT value of a column in a CREATE TABLE or ALTER TABLE statement

The condition of a CHECK constraint