Results 1 to 2 of 2
  1. #1
    Join Date
    May 2002
    Posts
    43

    Unanswered: Stored Procedure Date Stamp

    I am trying to create a list of when all the stored procedures in my database were compiled.

    Any help would be appriciated....

    Thanks....

  2. #2
    Join Date
    Jun 2004
    Location
    Liverpool, NY USA
    Posts
    2,509
    SELECT P.OWNER ,
    P.OBJECT_NAME ,
    P.OBJECT_TYPE,
    P.STATUS ,
    P.CREATED,
    P.LAST_DDL_TIME
    FROM ALL_OBJECTS P
    WHERE P.OBJECT_TYPE IN ('FUNCTION','JAVA SOURCE','PACKAGE','PACKAGE BODY','PROCEDURE')
    ORDER BY OBJECT_TYPE,OWNER,OBJECT_NAME;


    CREATED - Timestamp for the creation of the object
    LAST_DDL_TIME - Timestamp for the last modification of the object resulting from a DDL command (including grants and revokes)
    Bill
    You do not need a parachute to skydive. You only need a parachute to skydive twice.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •