Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2002
    Posts
    227

    Unanswered: data created trigger

    hi,
    I'd like to know if I can see the date created of a trgger.

    I tried with tables USER_TRIGGERS and USER_OBJECTS but I haven't when my trigger has created first time.


    Thanks
    RaF

  2. #2
    Join Date
    Sep 2003
    Posts
    156

    Re: data created trigger

    Originally posted by raf
    hi,
    I'd like to know if I can see the date created of a trgger.

    I tried with tables USER_TRIGGERS and USER_OBJECTS but I haven't when my trigger has created first time.


    Thanks
    RaF
    SQL> desc user_objects;
    Name Null? Type
    ----------------------------------------- -------- ----------------------------
    OBJECT_NAME VARCHAR2(128)
    SUBOBJECT_NAME VARCHAR2(30)
    OBJECT_ID NUMBER
    DATA_OBJECT_ID NUMBER
    OBJECT_TYPE VARCHAR2(18)
    CREATED DATE
    LAST_DDL_TIME DATE
    TIMESTAMP VARCHAR2(19)
    STATUS VARCHAR2(7)
    TEMPORARY VARCHAR2(1)
    GENERATED VARCHAR2(1)
    SECONDARY VARCHAR2(1)

    SQL> select to_char(created, 'YYYY MON DD HH24:MM SS') from user_objects where object_type ='TRIGGER
    ' and object_name like '%TRIGGER%';

    no rows selected

    SQL> as you can see my user doesnt have any triggers... but that should work, if you are using TOAD, you can ghet all the stats in one click
    rgs,

    Ghostman

  3. #3
    Join Date
    Apr 2003
    Location
    Greenville, SC (USA)
    Posts
    1,155
    select created,last_ddl_time from user_objects where object_name =

    This shows the date the object was created and the date of the last
    DDL to the object.

    Gregg

Posting Permissions

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