******************************************************************
* Description: SQL for Querying Object Last DDL Modification Time
* Compatiablity: RDBMS 10g, 11g, 12c
* Date: 23:20 PM EST, 01/09/2017
******************************************************************


SQL> SELECT object_name, object_type, last_ddl_time FROM dba_objects WHERE owner = 'TEST' AND object_name = 'PART_WORK_HISTORY';

     OBJECT_NAME                              OBJECT_TYPE         LAST_DDL_TIME
     ---------------------------------------- ------------------- --------------------
     PART_WORK_HISTORY                        TABLE               13-NOV-2014 11:48:39