Query the records of a table deleted by mistake during a certain period of time!

Sometimes some data in a table is accidentally deleted during database operations, in this case, you can query the records of a table deleted by mistake in a certain period of time to restore the data.

 

The SQL statement used to query records of tables accidentally deleted in a certain period of time is as follows:

Select * From table_name as of Timestamp to_timestamp (timestamp_value, 'yyyy-MM-DD hh24: MI: ss ');

 

Note: This statement only applies when table_name has a real deletion record. Otherwise, it cannot be executed.

 

 

In addition, when querying a table, you may need to filter out pure and non-full numbers. You can use the functions provided in Oracle to complete this function.

Translate (<column_name>, 'a0124356789 ', 'A ')

 

This function is used to query non-numeric content and numeric content in a field value. If it is all numeric content, it is null. Otherwise, only the non-numeric part is retrieved.