返回顶部

收藏

oracle建表备份脚本,如果update的数据不对,可以从WEB_RI_PLYEDR_CED_BAK找回

更多
--oracle建表备份脚本,如果update的数据不对,可以从WEB_RI_PLYEDR_CED_BAK找回
create table WEB_RI_PLYEDR_CED_BAK as
select  * from WEB_RI_PLYEDR_CED C where C.c_Ply_No in ('1100107000102001120150000022',
'1100107000102001120150000013',
'1100107000102001120150000017',
'1100107000101000320150000002'
) AND C.C_DOC_TYP ='E'and  C.N_TMS=2 and C.n_Edr_Prj_No=1;

update WEB_RI_PLYEDR_CED C set C.N_TMS=1 where C.c_Ply_No in ('1100107000102001120150000022',
'1100107000102001120150000013',
'1100107000102001120150000017',
'1100107000101000320150000002'
) AND C.C_DOC_TYP ='E'and  C.N_TMS=2 and C.n_Edr_Prj_No=1;
commit;

标签:sql

收藏

0人收藏

支持

0

反对

0

发表评论