把一个表的数据插入到另一个表中
insert into userareaterminal (id,areaid,mobilenumber,terminalid,status)
select SEQ_USERAREATERMINAL_ID.NEXTVAL,2,t.mobilenumber, t.terminalid,0 from terminalmanage t;
insert into userareaterminal (id,areaid,mobilenumber,terminalid,status)
select SEQ_USERAREATERMINAL_ID.NEXTVAL,2,t.mobilenumber, t.terminalid,0 from terminalmanage t;