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;