ORACLE序列NEXTVAL的使用范围

最新推荐文章于 2024-03-27 11:27:54 发布

原创最新推荐文章于 2024-03-27 11:27:54 发布 · 211 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#oracle sequence #数据库 #序列

本文详细介绍了在SQL中不能使用CURRVAL和NEXTVAL的特定构造，包括子查询、视图查询、DISTINCT操作、GROUP BY和ORDER BY子句、联合查询、WHERE子句、列默认值、CHECK约束条件。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

Restrictions on Sequence Values You cannot use CURRVAL and NEXTVAL in the
following constructs:
■ A subquery in a DELETE, SELECT, or UPDATE statement
■ A query of a view or of a materialized view
■ A SELECT statement with the DISTINCT operator
■ A SELECT statement with a GROUP BY clause 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
■ The DEFAULT value of a column in a CREATE TABLE or ALTER TABLE statement
■ The condition of a CHECK constrain