Hi all, how do i get the table,procedure and functions last updated date time. Any help highly appreciated. Thanks
Hi, You may query the view DBA_OBJECTS and observe the column LAST_DDL_TIME. Please notice that this timestamp is only the last DDL statement time that affect the db object, not for those DML statements like INSERT, UPDATE ...etc. Eddy Ng
Thanks it works
Forum Rules