create table TEMP_IMP_A ( id NUMBER, col VARCHAR2(100) );insert into TEMP_IMP_A(col) VALUES('aaa'); insert into TEMP_IMP_A(col) VALUES('bbb'); insert into TEMP_IMP_A(col) VALUES('ccc');create sequence id_sequence INCREMENT BY 1 START WITH 1 NOMAXVALUE NOCYCLE CACHE 10;update TEMP_IMP_A set id = id_sequence.nextval;
(
id NUMBER,
col VARCHAR2(100)
);insert into TEMP_IMP_A(col) VALUES('aaa');
insert into TEMP_IMP_A(col) VALUES('bbb');
insert into TEMP_IMP_A(col) VALUES('ccc');create sequence id_sequence INCREMENT BY 1 START WITH 1 NOMAXVALUE NOCYCLE CACHE 10;update TEMP_IMP_A set id = id_sequence.nextval;