oracle – ORA-02287：此处不允许使用序列号

发布时间：2020-12-12 13:12:18 所属栏目：百科来源：网络整理

导读：我试图从两个表中选择值并将它们插入一个表中,并计算每年总计的展示位置数.我一直收到一个错误,说这里不允许序列 DROP table placement_cal CASCADE CONSTRAINTS;CREATE TABLE placement_cal( cal_id INTEGER NOT NULL,year INTEGER,no_of_placements INTEGE

我试图从两个表中选择值并将它们插入一个表中,并计算每年总计的展示位置数.我一直收到一个错误,说这里不允许序列

DROP table placement_cal CASCADE CONSTRAINTS;

CREATE TABLE placement_cal(
    cal_id  INTEGER NOT NULL,year    INTEGER,no_of_placements INTEGER,CONSTRAINT  pk_cal_dim PRIMARY KEY (cal_id)
);


INSERT INTO placement_cal (
SELECT cal_id.nextval,EXTRACT(YEAR FROM start_date),count(placement_id)
FROM placement
group by year);

INSERT INTO placement_cal (
SELECT cal_id.nextval,count(placement_id)
FROM placement_two
group by year);

你可以在 FAQ得到原因

The following are the cases where you can’t use a sequence:

For a SELECT Statement:

In a WHERE clause

In a GROUP BY or ORDER BY clause

In a DISTINCT clause

Along with a UNION or INTERSECT or MINUS

In a sub-query

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!