数据库误操做恢复语句

（说明oracle数据库：）数据库

create table nw_co_tmpl_temp as
select * from nw_co_tmpl as of timestamp sysdate -1/24;

select * from nw_co_tmpl;

update nw_co_tmpl t
set t.title=(SELECT title from nw_co_tmpl_temp a where a.tmpl_key=t.tmpl_key and a.lang_tp_cd=t.lang_tp_cd)
where t.tmpl_key in (SELECT tmpl_key from nw_co_tmpl_temp);

 oracle