Profile Answers by rajanipriya Questions by rajanipriya. Its only update , delete, insert , before , after ,, row level and statemant level triggers. Higher version of Oracle doesn't have any limitation of the number of trigger.
Earlier 12 number of triggers were fired per table. With Oracle 10g : any number of trigger can be written on a table. With Oracle 9. You can create n number of triggers, try the below trigger on a same table by giving different names with different when conditions.
In oracle 11g , there is no limit for number of triggers on a table. There is no limit to the no. Base on presented choices and correct answer the question should be "How many different types of triggers exist", which is 3 before statement, 3 after statement, 3 before each row and 3 after each row. Nick AM. It is unlimited You can have all types of triggers per each column. And there is nothing stopping you writing multiple triggers per column per operation.
But in practice you wont create more than 6 or 7 triggers. If u want to create more than that then check ur datbase design and business requirement once again. With Oracle 10g any number of trigger can be written on a table. With Oracle 9. I seem to recall reading that a future version Oracle 11? No Account? Sign up. By signing in, you agree to our Terms of Use and Privacy Policy. I see triggers as a mixed bag. I use them but only when I think they are the most elegant way of handling a problem.
I think that the. In a small database where you can be intimately familiar with all the tables it's easier to remember that they are there and operating. In a database with hundreds of tables and only a hand full of triggers, well Things can be forgotten easier.
Just a guess as to what the poster was thinking though. Gail Shaw.
0コメント