select name from tbl union all select '复制'||name from tbl
insert into select rownum as str1,str2 from test,(select level from dual connect by level <=2)<=多少自己调
insert into table(name) select'复制'||name from table;
最简单的 方法 insert into table(id,name) value(SEQ_table_ID.nextval ,select '复制'||name from table where in=1);insert into table(id,name) value(SEQ_table_ID.nextval ,select '复制'||name from table where in=2);
insert into table select SEQ_table_ID.nextval,'[复制]'||name from table;
select name from tbl
union all
select '复制'||name from tbl
insert into table(id,name) value(SEQ_table_ID.nextval ,select '复制'||name from table where in=1);insert into table(id,name) value(SEQ_table_ID.nextval ,select '复制'||name from table where in=2);
insert into table
select SEQ_table_ID.nextval,'[复制]'||name from table;