根据表＃1中列的值将表数据从表＃1复制到表＃2

Question

Table#1: workorders 
columns: 
dept_name, 
dept_code, 
validity_work_order 
work_order_no //primary key 

Table#2: History_workorders 
columns: 
dept_name, 
dept_code, 
validity_work_order 
work_order_no //primary key 

我的要求是将表＃1中的所有记录复制到表＃2，其有效性已过期，然后将它们从表格1。 我正在使用Oracle 10g R2快捷版

Answer 1

INSERT INTO History_workorders SELECT * FROM workorders WHERE validity_work_order < sysdate 

Delete from workorders where work_order_no in(select work_order_no from History_workorders); 

我希望你在这里提出了完整的要求。以上代码中的 可能需要根据您的需要进行一些更改。

Answer 2

insert into History_workorders 
select * from workorders 
where validity_work_order='Expired'; 
delete from workorder where validity_work_order='Expired';