17,086
社区成员
发帖
与我相关
我的任务
分享
--用序列
create sequence seqid
start with 1
increment by 1
cache 10
insert into b select a.*,seqid.nextval from A
CREATE TABLE t_a(id number,col1 number,col2 number);
CREATE TABLE t_b(col1 number,col2 number);
INSERT INTO t_b VALUES(1,1);
INSERT INTO t_b VALUES(2,2);
COMMIT;
INSERT INTO t_a SELECT ROWNUM,t_b.* FROM t_b;
SELECT * FROM t_a;
insert into b select * ,seq.nextval from a
insert into b select a.*,sequence.nextval from a;
--建立sequence
create sequence seq
increment by 1
start with 1
nocycle
insert into B select a.* seq.nextval from a