Last DDL timestamp of objects or codes in Oracle Database

Introduction:

In this blog post today, I am going to discuss about the last DDL time stamp of any objects in Oracle Database. Now before I start let me give you brief introduction about DDL and DML.

DDL :

 - It stands for Data Definition Language.

 - Basic commands in DDL are create, drop, rename, alter etc

DML :

 -  It stands for Data Manipulation Language.

-  Basic commands in DDL are update, insert, merge etc

Query to know DDL Time stamp.

           sql> select OBJECT_NAME, CREATED, LAST_DDL_TIME, status from user_objects
                   where  OBJECT_NAME=’DB_VERIFY_FUNCTION_ADMIN';

   OBJECT_NAME                                CREATED            LAST_DDL_TIME             STATUS

------------------ ---------- ------------------------------ ------------------ ----------------- -----------------------------

  DBVERIFY_FUNCTION_ADMIN      21-SEP-08           00:43:11 20-FEB-09           VALID

SQL> select sysdate from dual;

       SYSDATE

      ------------------

       20-FEB-09 11:02:47