创建自增id
create table TEMP
(
id NUMBER not null,
account_id VARCHAR2(30),
type VARCHAR2(3),
day3_ CLOB
)
创建序列
create sequence wottemp.temp_id_seq start with 1 increment by 1;
使用序列插入自增id
insert into wottemp.temp(id,account_id,type,day3_)
select wottemp.temp_id_seq.nextval,uvh.account_id,0,33 from wottemp.temp