Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2003

    Unanswered: List all triggers created.

    Hi guys, many thanks for your previous help, it's been invaluble. One last thing though. I only found out how to spool all commands to a log file after I had begun constructing my DB, now I can't remember some of the triggers/sequences etc that I created before that. Is there any way in Oracle SQLPlus to list all triggers/sequences etc (and perhaps the sequences current values) that I created?


  2. #2
    Join Date
    Nov 2003
    Rotterdam, Netherlands
    You should query USER_TRIGGERS view and USER_SEQUENCES view to find the list

    u can also get them in
    USER_OBJECTS where object_type in ('TRIGGER','SEQUENCE');

    Hope this helps u


Posting Permissions

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