Stepwise-Lab

ORA-02287: Sequence number not allowed here

NEXTVAL and CURRVAL are not allowed in WHERE, GROUP BY, ORDER BY, DISTINCT queries, set operators, subqueries or views.

On the exam

This error belongs to the topic Views, sequences, indexes of exam 1Z0-071.

In the SQL lab the same explanation appears next to your own statement, with a hint about what to change in it.

All Oracle errors