Before row level trigger WHEN clause => FALSE, but body still looks executed according to plan
Hi
Oracle 19c
I have a row level trigger that fires before update or insert. It will change a date column after every insert/update.
Now I have added WHEN clause. So it should execute body only if user is not RAULKAUBI.
WHEN (USER != 'RAULKAUBI')
WHEN (condition)
Specifies a SQL condition that the database evaluates for each row that the triggering statement affects. If the value of condition is TRUE
for an affected row, then trigger_body