oracle sql语句序列,Oracle SQL：使用Select语句插入序列

假设您要在按序列生成密钥之前对数据进行分组，那么就像您想要的那样

INSERT INTO HISTORICAL_CAR_STATS (

HISTORICAL_CAR_STATS_ID,

YEAR,

MONTH,

MAKE,

MODEL,

REGION,

AVG_MSRP,

CNT)

SELECT MY_SEQ.nextval,

year,

month,

make,

model,

region,

avg_msrp,

cnt

FROM (SELECT '2010' year,

'12' month,

'ALL' make,

'ALL' model,

REGION,

sum(AVG_MSRP*COUNT)/sum(COUNT) avg_msrp,

sum(cnt) cnt

FROM HISTORICAL_CAR_STATS

WHERE YEAR = '2010'

AND MONTH = '12'

AND MAKE != 'ALL'

GROUP BY REGION)