

























1.to backup tblPermission into tblPermissionBak. If tblPermissionBak does not exist, Create the table and insert all data of tblPermission into tblPermissionBak. If tblPermissionBak exists, insert all datas without create table.
declare cnt integer;
Begin
select count(*) into cnt from all_tables where table_name=Upper('tblPermissionBak');
if(cnt<=0) then
execute immediate 'create table tblPermissionBak as (select * from tblPermission)';
else
execute immediate 'truncate table tblPermissionBak';
execute immediate 'insert into tblPermissionBak (select * from tblPermission)';
end if;
End;
/
commit;
2.to retore table
truncate table tblPermission;
insert into tblPermission (select * from tblPermissionBak);
commit;
此内容由惯性聚合(RSS阅读器)自动聚合整理,仅供阅读参考。 原文来自 — 版权归原作者所有。