oracle sequences的问题．

[simonzjx]

我现在有一张空表A，有四个字段ID，C,D,E.(ID为sequences，名称为SEQ_TOTALTYPE)现在要从另一张表B中选三个字段插入到A表的C,D,E字段．这个时候应该怎么样插入sequences字段的值？
　　insert into A(SEQ_TOTALTYPE.nextVal,C,D,E) select C,D,E from B这样会出错．应该怎样写呢？

[子陌红尘]

insert into A select SEQ_TOTALTYPE.nextVal,C,D,E from B

[simonzjx]

先谢谢libin_ftsafe，现在我还要对B表中取出的数据进行distinct处理，应该怎么写？

[wgsasd311]

进行distinct处理，应该怎么写？
==>
insert into A select SEQ_TOTALTYPE.nextVal,C,D,E from (select distinct * from B)

[子陌红尘]

insert into A
select
SEQ_TOTALTYPE.nextVal,v.*
from
(select distinct C,D,E from B) as v