insert into table1(developid) select mysequence.nextval from table2 t2 group by t2.fieldname; 这个会报 "此处不能为序列"的问题!原因可能是group by 的问题。但现在的问题是 我既想用sequence 又想用group by 这个该怎么解决呢?还请各位指点指点!
调试欢乐多
这样呢。
select mysequence.nextval
from (select 1 from table2 t2 group by t2.fieldname);
可以用子查询!
insert into table1(developid) select mysequence.nextval from (select 1 from table2 t2 group by t2.fieldname);