Re: Pre-DML trigger vs Foreign keys
> Her point is instead of using 2 foreign keys we can get it done from single select statement.
Nonsense on stilts. A foreign key is faster, requires less code than the three triggers that would be required to replicate its functionality, is less error-prone, and works in all environments (many shared hosting providers screw up trigger implementations).
Subject
Views
Written By
Posted
2632
June 22, 2012 10:16AM
1272
June 22, 2012 11:41AM
1268
June 23, 2012 01:35AM
Re: Pre-DML trigger vs Foreign keys
1280
June 24, 2012 08:04AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.