ORA-02287：Oracle序列的使用限制

在开发过程中，突然遇到ORA-02287错误 “此处不允许序号”
初始的sql是这样的
select s_id.nextval, a.name, a.dept, max(b.score)
from tableA a
left join tableB b
on b.user_code = a.code

之前另一个类似的sql没有使用max（）是可以正常执行的，因此基本定位是max函数导致的这个问题。

网络搜索发现，oracle的序列有一堆使用限制条件的
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

修正后，sql为：
select s_id.nextval, a.name, a.dept, b.score
from tableA a
left join
(
select user_code, max(b.score) score from TableB
group by user_code
)b
on b.user_code = a.code

sql正常执行，并取得预期结果。