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