oracle 将一个表的数据插入另一张表

tableA:

 

id	tel	name
1	00000001	张三
2	00000002	李四

 

tableB:

id	tel	name

 

 

将a表的数据插入到b表  b表为空表

 

insert into tableB(id, tel, name)

select a.id, a.tel, a.name

/*
(case when t.bautoid = '1' then '2' 
when t.bautoid = '2' then '1'
when t.bautoid = '3' then '4'
when t.bautoid = '5' then '3'
end),

*/
from tableA a