在调用序列的CURRVAL
和NEXTVAL方法时,在一下SQL结构禁止使用
-
A subquery in a
DELETE
,SELECT
, orUPDATE
statement -
A query of a view or of a materialized view
-
A
SELECT
statement with theDISTINCT
operator -
A
SELECT
statement with aGROUP
BY
clause orORDER
BY
clause -
A
SELECT
statement that is combined with anotherSELECT
statement with theUNION
,INTERSECT
, orMINUS
set operator -
The
WHERE
clause of aSELECT
statement -
The
DEFAULT
value of a column in aCREATE
TABLE
orALTER
TABLE
statement -
The condition of a
CHECK
constraint