Looking for docs on the semantics of triggering statements (especially as related to Foreign Keys)
Is there documentation on what exactly constitutes a triggering statement as used in https://docs.oracle.com/en/database/oracle/oracle-database/19/lnpls/plsql-triggers.html. Especially as to how the existence of foreign keys causes tables other than those directly affected to be triggered. Basically i have encountered some non-intuitive behavior that appears to be "by design" so i am looking for confirmation that this is the intended behavior, but have been unable to find anything on the subject.
We are using a compound trigger with a BEFORE STATEMENT to do some checks similar to the example in 9.3.4.7 https://docs.oracle.com/en/database/oracle/oracle-database/19/lnpls/plsql-triggers.html#GUID-9E6E59EF-F402-4B11-A4FF-268D9C0521EB