- 08 Sep, 2023
- 0 Comments
- 20 Secs Read
Last modified table
Last modified table
Sometimes Application team might asked you to provide details of last modified table in oracle. So just run the below query :
1 2 3 4 5 6 7 | set linesize 500;select TABLE_OWNER, TABLE_NAME, INSERTS, UPDATES, DELETES, to_char(TIMESTAMP,'YYYY-MON-DD HH24:MI:SS')from all_tab_modificationswhere table_owner<>'SYS' andEXTRACT(YEAR FROM TO_DATE(TIMESTAMP, 'DD-MON-RR')) > 2010order by 6; |