Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2009
    Posts
    2

    Question Unanswered: Get all tables with a specified trigger

    Hello,

    Is there a way to select all the tables that have a specified trigger?

    Thank you,
    Ioana.

  2. #2
    Join Date
    Nov 2003
    Posts
    2,935
    Provided Answers: 12
    A trigger can only be "assigned" to a single table.
    So your question really is get the table that has a specified trigger.

    The information that you are looking for is stored in the system view ALL_TRIGGERS:

    http://download.oracle.com/docs/cd/B28359_01/server.111/b28320/statviews_2108.htm#i1592586

  3. #3
    Join Date
    Oct 2009
    Posts
    2
    Thank you very much.

Posting Permissions

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