How to find last ddl on a table in oracle
In this post , We will be discuss about How to find last ddl on a table in oracle. We will be share the sample sql query which helps to find the last ddl date on a table in oracle. We can find that , when the last ddl change happened for a table in oracle. This helps to keep track on the latest changes for any DB Tables. This is one of useful sql query for any DB Administrator. Here below is the detail about how to find last ddl on a table in oracle.
 |
| How to find last ddl on a table in oracle |
Important Table to find the last modified date of a table in oracle
1. USER_OBJECTSDetail SQL Query to find last ddl on a table in oracle
select object_name,object_type,
to_char(created,'DD-MM-YYHH24:MI:SS') Table_created,
to_char(last_ddl_time,'DD-MM-YY HH24:MI:SS') Table_last_ddl
from user_objects where object_name = 'Table_Name'
to_char(created,'DD-MM-YYHH24:MI:SS') Table_created,
to_char(last_ddl_time,'DD-MM-YY HH24:MI:SS') Table_last_ddl
from user_objects where object_name = 'Table_Name'
0 comments:
Post a Comment