1、
insert into b(a, b, c) select d,e,f from b;
insert into to_settlepath (csettlepathid,cpathcode,cpathname,coutcorpid,cincorpid,bdefault,vmemo,ts,dr)
(select pathid,pathcode,pathname ,begin_corp,end_corp,decode(ifenabled,'是','Y','N'),descr,ts,dr from zm_path)
2、create table newtable as select * from user.table;
create table tmp_to_inbidreic as ( SELECT SUM(num) AS numsum, SUM(nmny) AS nmnysum,cgeneralbid FROM tmp_to_inbidic GROUP BY cgeneralbid);