按excel 表格 更新oracle时间

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.创建临时表

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

2.清空临时表

delete t0903;

3.进入表数据编辑模式

select * from t0903 for update ;

 

4.粘贴数据到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 );