How to find ddl changes in oracle
In this post , We will be discuss about how to find ddl changes in oracle. We will be share the sample sql query which helps to find the last ddl change 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 ddl 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 ddl changes in oracle.
 |
| How to find ddl changes in oracle |
Important Table find ddl changes in oracle
1. USER_OBJECTSDetail SQL Query to find ddl changes 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