But, you may be wondering, why are triggers so hated? They can be hundreds of lines long and contain convoluted conditions.
Many developers dislike them because they fire silently in the background, seeming to live just beyond the fingertips of their control.
And it’s pretty unanimous – from luminaries like Tom “Triggers are evil” Kyte to people like this dude (“Triggers are powerful – and much despised”). To answer your question, let me start by quoting myself again: Simple triggers to populate primary key columns from sequences are pretty uncontroversial; however, there is no upper limit to their potential complexity.
Well, I dare you to walk into a room full of Oracle experts wearing an I ♥ DATABASE TRIGGERS t-shirt. Database triggers are the Oracle feature that developers love to hate, perhaps above every other.
Certain applications will use a lot of file descriptors.