Oracle database generates misoperation, empty a field, recovers data

The work of the time did not carefully check the SQL directly executed, the data on the line is mistaken, found to grasp the changes, fortunately, only modified a table column;

On the Internet, Oracle can query data for 24 hours at any time.

SELECT * FROM BTGL_YLBT_SQB t as of timestamp to_timestamp (' 2018-01-24 10:56:00 ', ' yyyy-mm-dd hh24:mi:ss '); --Query to this time data

-To restore this column to this moment

Update BTGL_YLBT_SQB SQB
Set sqb.duration =
(select Duration from BTGL_YLBT_SQB as of timestamp to_timestamp (' 2018-01-24 10:56:00 ', ' yyyy-mm-dd hh24:mi:ss ') a
where sqb.uuid = A.uuid);

Fortunately there is a solution, or this is an accident Ah!

Oracle database generates misoperation, empty a field, recovers data