Insert into aa(test1,test2,name) select (t1,t2,t3)from bb;
其中test1,test2为联合主键
因为aa.test1跟bb.t1相同,所以可否让test2的值自动加1,而不使用bb.t2
其中test1,test2为联合主键
因为aa.test1跟bb.t1相同,所以可否让test2的值自动加1,而不使用bb.t2
select t1,rownum,t3 from bb;
to yonghu/mima@zifuchuan -
create tablename -
using -
select * from tablename
例:aa.test1 test2 name bb.t1 t2 t3
1 1 aa 1 1 aa
2 2 bb 2 3 cc
2 3 cc 2 2 bb
不使用bb.t2,会出错的
---------- ----------------------------------SQL> insert into dinya_test01 values(rownum,'OK');1 row insertedSQL> insert into dinya_test01 values(rownum,'OK_02');1 row insertedSQL> commit;Commit completeSQL> select * from dinya_test01; ID NAME
---------- ---------------------------------------
0 OK
0 OK_02SQL>
--使用序列.sequenceSQL> create table dinya_test02( id number,name varchar2(100));Table createdSQL> create sequence seq_name
2 increment by 1
3 start with 1;Sequence createdSQL> insert into dinya_test02(id,name) select seq_name.nextval,t.name from dinya_test01 t;2 rows insertedSQL> commit;Commit completeSQL> select * from dinya_test02; ID NAME
---------- ------------------------------------------------
1 OK
2 OK_02SQL>
1 1 aa 1 1 aa
2 2 bb 2 3 cc
2 3 cc 2 2 bb
請幫忙插入
得到的結果為:
aa.test1 test2 name
1 1 aa
1 2 aa
2 2 bb
2 3 cc
2 4 cc
2 5 bb
1 1 aa 1 1 aa
2 2 bb 2 3 cc
2 3 cc 2 2 bb
請幫忙插入
得到的結果為:
aa.test1 test2 name
1 1 aa
1 2 aa
2 2 bb
2 3 cc
2 4 cc
2 5 bb