Discussions
Categories
- 197.1K All Categories
- 2.5K Data
- 546 Big Data Appliance
- 1.9K Data Science
- 450.7K Databases
- 221.9K General Database Discussions
- 3.8K Java and JavaScript in the Database
- 31 Multilingual Engine
- 552 MySQL Community Space
- 479 NoSQL Database
- 7.9K Oracle Database Express Edition (XE)
- 3.1K ORDS, SODA & JSON in the Database
- 555 SQLcl
- 4K SQL Developer Data Modeler
- 187.2K SQL & PL/SQL
- 21.3K SQL Developer
- 296.3K Development
- 17 Developer Projects
- 139 Programming Languages
- 293K Development Tools
- 110 DevOps
- 3.1K QA/Testing
- 646.1K Java
- 28 Java Learning Subscription
- 37K Database Connectivity
- 158 Java Community Process
- 105 Java 25
- 22.1K Java APIs
- 138.2K Java Development Tools
- 165.3K Java EE (Java Enterprise Edition)
- 19 Java Essentials
- 162 Java 8 Questions
- 86K Java Programming
- 81 Java Puzzle Ball
- 65.1K New To Java
- 1.7K Training / Learning / Certification
- 13.8K Java HotSpot Virtual Machine
- 94.3K Java SE
- 13.8K Java Security
- 204 Java User Groups
- 24 JavaScript - Nashorn
- Programs
- 466 LiveLabs
- 39 Workshops
- 10.2K Software
- 6.7K Berkeley DB Family
- 3.5K JHeadstart
- 5.7K Other Languages
- 2.3K Chinese
- 175 Deutsche Oracle Community
- 1.1K Español
- 1.9K Japanese
- 233 Portuguese
Regarding Trigger costraint

There is a table say T1 where in data is inserted in T1 through database link from other database. A Trigger on T1 table inserts data in another table T2.
Is it possible to have another insert trigger on table T2 which inserts data in another table T3.
Is there any constraint in defining trigger on table T2 ?
Answers
-
bootstrap wrote:There is a table say T1 where in data is inserted in T1 through database link from other database. A Trigger on T1 table inserts data in another table T2.Is it possible to have another insert trigger on table T2 which inserts data in another table T3.Is there any constraint in defining trigger on table T2 ?
no
What problem are you trying to solve?
Please read & follow URL below
How do I ask a question on the forums?
https://asktom.oracle.com/pls/apex/f?p=100:11:0::::P11_QUESTION_ID:2575882200346616184
http://www.oracle.com/technetwork/testcontent/o58asktom-101055.html
http://rwijk.blogspot.com/2007/09/database-triggers-are-evil.html
https://stackoverflow.com/questions/460316/are-database-triggers-evil -
bootstrap wrote:There is a table say T1 where in data is inserted in T1 through database link from other database. A Trigger on T1 table inserts data in another table T2.Is it possible to have another insert trigger on table T2 which inserts data in another table T3.Is there any constraint in defining trigger on table T2 ?
Technically, no. But this is very suggestive of a poorly thought out design. What is the relationship of the three tables, and what business purpose is achieved by these cascading triggers?
-
but don't forget https://www.oracle.com/technetwork/testcontent/o58asktom-101055.html
"Triggers should be the exception, not the rule. They should be used only when you cannot do something any other way."
-
bootstrap, we have a process running on a factory server that inserts a row into a materials server table with an insert row trigger which then inserts into another table with an insert row trigger until six such triggers fire. The last trigger inserts a row back to the source database. Control is returned to the caller at which point the program reads the return row. This process has worked without issue since version 7.x.
- -
Basic rule - trigger code should only act upon another table and when target tables have triggers the logic should never refer back to a prior tables in the stream. Don't use additional triggers where the first trigger or calling process could just perform multiple DML operations itself.
- -
HTH -- Mark D Powell --
-
Is it possible to have another insert trigger on table T2 which inserts data in another table T3.
What happened when you tried it?
Is there any constraint in defining trigger on table T2 ?
What happened when you tried it?
The BEST, and often fastest, way to learn is: TRY IT AND SEE!