drop table t0903;
create table t0903 as select END_TIME,id from CLASS_RECORD_LINE x WHERE ID = 104396;
delete t0903;
select * from t0903 for update ;

update class_record_line  x set x.end_time=(select end_time  from t0903 cc where cc.id=x.id)
where exists (select 1 from   t0903 t where t.id=x.id );

1.創(chuàng)建臨時表

create table t0903 as select END_TIME,id  from CLASS_RECORD_LINE x WHERE ID = 104396;

2.清空臨時表

delete t0903;

3.進入表數(shù)據(jù)編輯模式

select * from t0903 for update ;

4.粘貼數(shù)據(jù)到plsqldev

5.更新目標表

update class_record_line  x set x.end_time=(select end_time  from t0903 cc where cc.id=x.id)
where exists (select 1 from   t0903 t where t.id=x.id );