求sql语句

Question

tb1
id    name
1     a
2     btb2
id      name    oid
1       a        1
2       b        2怎样把表一的数据插入到表二中？oracle

Answer 1

insert into table1(column1,column2) select * from table2(column1,column2)

Answer 2

insert into table1(column1,column2) select (column1,column2) from table2

Answer 3

Quote: 引用 2 楼 tonypingge 的回复:

select 后木有() 

Answer 4

insert into tb2 (id,name) select id,name from tb1

Answer 5

insert into tb2  select id，name，‘’ as oid  from tb1如果第三列需要数字的话  把 ‘’ 替换成 rownum

Answer 6

insert into table1(column1,column2) select column1,column2 from table2