insert的时候select，update的时候create。exists相当于in

insert into tp_menu(MENU_ID,menu_name,parent_id,order_no,menu_url,img_url,status,process,activity,flag)
select '11111111111111','额度冻结',868,4,'ftzf/czglxt/plan/authfreeze/authfreeze.jsp','',1,'6630','mainActivity','1'  from dual

 

 

 create table   tb_pay_info2   as  
 select *  from   tb_pay_info t where paytype_id = 3  and is_cancel = 1  and is_clear = 1   and SETTLETYPE_ID = 7

 

---------------------2

select *  from t_pubagency  t where isnew=0 and not  exists(select 1  from t_pubagency t1 where t.code=t1.code and t1.isnew=1 )