(Small note) () Oracle bulk copy data from a data table, modify some fields and append to the datasheet ____oracle

INSERT INTO Jwxt.jy_zyxx A (a.jxjhh, A.SSXQDM, A.nj, A.ZYDM, A.XKLBDM, a.rs, A.bjs, A.ZSKCS, A.ZDBYXF, a . GGBXXF, A.GGXXXF, A.XKBXXF, A.XKXXXF, A.ZYBXXF, A.zyxxxf1, A.zyxxxf2, A.SJKXF, A.FSSJXF, A.JQSJXF, a. 
  YYFJXF, A.KWXF, A.TSBXXF, A.TSXXXF, A.DLBXXF, A.FLXXXF, A.KNSYXF, A.DEXWXF, A.bybz, A.xwsybz, A.GXKXF, A.XXYSYZDXF, A.WHKCXF, A.KJWHKCXF, A.YSKCXF, A.xxfyq, A.xynx, A.fxnx, a.bz, A.zt, A.GXKCXF, A.kcly2 , A.kcly3, A.kcly4, A.kcly5, A.kcly6, A.kcly7, A.kcly8, A.kcly9, A.kcly10, A.KCLY1) Select ' 2014 ' | | SUBSTR (b.jxjhh,5,4), string connection with intercept b.ssxqdm, ' 2014 ', B.ZYDM, B.XKLB DM, b.rs, B.BJS, B.zskcs, B.ZDBYXF, B.GGBXXF, B.GGXXXF, B.XKBXXF, B.XKXXXF, B.ZYBXXF, B.zyxxxf1, b.z Yxxxf2, B.SJKXF, B.FSSJXF, B.JQSJXF, B.YYFJXF, B.KWXF, B.TSBXXF, B.TSXXXF, B.DLBXXF, B.FLXXXF, B.knsyx
F, B.DEXWXF, B.bybz,  B.xwsybz, B.GXKXF, B.XXYSYZDXF, B.WHKCXF, B.KJWHKCXF, B.YSKCXF, B.xxfyq, B.xynx, B.fxnx, b.bz, B.zt,  
B.GXKCXF, B.kcly2, B.kcly3, B.kcly4, B.kcly5, B.kcly6, B.kcly7, B.kcly8, B.kcly9, B.kcly10, b.kcly1                                                                              From Jwxt.jy_zyxx b where b.zt=1 and b.jxjhh like ' 2013% ' and b.jxjhh not in (' 20132188 ',  Remove constraint violation record ' 2013218I ', ' 20134011 ', ' 2013407J ') select * from Jwxt.jy_zyxx
 b where b.zt=1 and b.jxjhh like ' 2014% ' test the results

//////////////

INSERT INTO JWXT. Jy_pyjhyq T ( 
t.jxjhh,t.pyjhzwmc,t.zt
)
Select 
zyxx.jxjhh,zy.zymc| | ' Level 2014 training Program ', 1 from
 jwxt.jy_zyxx Zyxx left 
 join Jwxt.sys_zy zy on zy.zydm = ZYXX.ZYDM 
 where zyxx.jxjhh like ' 201 4% ' and zyxx.jxjhh not in (
 ' 20142188 ',
' 2014218I ',
' 20144011 ',
' 2014407J '
 )