oracle建表备份数据,oracle建表备份脚本，如果update的数据不对，可以从WEB_RI_PLYED...

无详细内容 无 --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中文网，转载请注明出处，感谢您的尊重！