Results 1 to 4 of 4
  1. #1
    Join Date
    Feb 2004
    Location
    Chennai
    Posts
    53

    Post Unanswered: what is the max no of triggers a table can have in oracle

    what is the max no of triggers a table can have in oracle

  2. #2
    Join Date
    Jan 2004
    Location
    India
    Posts
    191

    Re: what is the max no of triggers a table can have in oracle

    Maximum 12 triggers can be created on the table.
    1)Six row level
    2) siz statement level

    Thanks,
    Pagnint
    (No need to search web before posting new question)

  3. #3
    Join Date
    Feb 2004
    Location
    Chennai
    Posts
    53

    Re: what is the max no of triggers a table can have in oracle

    Thanks paginit

  4. #4
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171
    Provided Answers: 1

    Re: what is the max no of triggers a table can have in oracle

    12 is the maximum number of different types of trigger, but there is no limit to the number of triggers of each type. However, when there is more than 1 trigger of the same type on a table, the order of execution cannot be controlled.

Posting Permissions

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