How to view recently modified tables in Oracle

Modifying a project involves modifying many tables in Oracle (including adding, deleting fields, and modifying comments ). As no records are recorded at the beginning, the tables that have been modified are missing during the test. Later, I found some materials on the Internet, such:

 

1,Select UAT. table_name from user_all_tables UATThis SQL statement can obtain the names of all user tables.

2,Select object_name, created, last_ddl_time from user_objectsThis SQL statement obtains the creation and last modification time of all user objects (including tables ).

 

Based on the preceding SQL statements, the following statements are summarized:

 

Select UAT. table_name as table name, (select last_ddl_time from user_objects where object_name = UAT. table_name) as last modification date
From user_all_tables UAT

This statement can be used to obtain the last modification time of all tables. (You can add the corresponding conditional expression after the SQL statement according to the actual situation)

 

By sorting the last modification time in descending order in the query results, you can know that the structure of those tables has been modified.

 

In addition, I hope you can practice the SQL statements mentioned above. They can implement many other useful functions. I hope you can study ^_^ more!