将一张表中数据插入到另外一张中的脚本

最新推荐文章于 2021-05-10 00:08:38 发布

DEMO_LOMO

最新推荐文章于 2021-05-10 00:08:38 发布

阅读量584

点赞数

本文链接：https://blog.csdn.net/DEMO_LOMO/article/details/52036239

版权

insert into sw_dj_djxx
(NSRSBH,
ZZJGDM,
NSRMC,
XZQH_DM,
SWJG_DM,
HY_DM,
NSRZT_DM,
SWDJBLX_DM,
ZCDZ,
SCJYDZ,
LSGX_DM,
HSFS_DM,
INSERT_TIMESTAMP,
UPDATE_TIMESTAMP,
YXBZ,
DATA_ID,
JYFW,
SCJYQXQ_RQ,
SCJYQXZ_RQ,
NSRZT_MC,
FDDBRZJLX,
FDDBRZJHM,
LR_RQ,
LXDH,
FDDBR_MC,
ZCZB_JE,
LY_BZ,
FRDM,
TYSHXYDM,
DJZCLX_DM)
select NSRSBH,
ZZJGDM,
NSRMC,
XZQH_DM,
SWJG_DM,
HY_DM,
NSRZT_DM,
SWDJBLX_DM,
ZCDZ,
SCJYDZ,
LSGX_DM,
HSFS_DM,
INSERT_TIMESTAMP,
UPDATE_TIMESTAMP,
YXBZ,
DATA_ID,
JYFW_ZY,
to_date(a.SCJYRQ_Q,'YYYY/MM/DD') SCJYRQ_Q,
to_date(a.SCJYRQ_Z,'YYYY/MM/DD') SCJYRQ_Z,
NSRZT_DM,
FRZJLX_DM,
FRZJHM,
TO_DATE(a.DJRQ,'YYYY/MM/DD') djrq,
FRDH,
FRXM,
ZCZB,
SJLY,
SWGLM,
NSRSBH,
ZCLX_DM
from rc_czck.sw_s_dj_nsrxx a where sjly = '1'