oracle备份表和数据

oracle 备份数据

如果备份表存在

原表t_base_employee,备份表t_base_employee20180718 
insert into t_base_employee0718 select * from t_base_employee;



如果备份表不存在

原表t_base_employee

create table t_base_employee20180718 as select * from t_base_employee ;


删除表数据

delete  from t_base_employee;





--在myTable 中添加一条学生的数据 ；
insert into myTable (id, type, code, name, parent_code,sync_flag) values ('110', 'student', '01', '学生', '00','');
commit;