You can use EM to create the trigger.  Within the trigger code, use the same SQL statement that you would use if doing it manually, but do you select from either...

Thanks. Worked perfectly.

Any possible way of doing this per database ?

The production system is running many other apps not written by ourselves, and I don't want to affect any of the other...