oracle建表备份脚本,如果update的数据不对,可以从WEB_RI_PLYED
程序员文章站
2024-02-12 12:15:40
...
无详细内容 无 --oracle建表备份脚本,如果update的数据不对,可以从WEB_RI_PLYEDR_CED_BAK找回create table WEB_RI_PLYEDR_CED_BAK asselect * from WEB_RI_PLYEDR_CED C where C.c_Ply_No in ('1100107000102001120150000022','110010700010200112015000001
--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;
上一篇: php给图片加水印实例函数_PHP教程
下一篇: PDO查询不成功!