Skip to Main Content
Forums

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Setup a Email trigger with specific Oracle table

User_MH06LNov 21 2018 — edited Nov 22 2018

Hi,

I Have a table called TEST_TABLE. I need to get an email alert, if any changes happened in this table (like insert,update,delete & drop).

I Have few options in my mind, using DB trigger or DB Auditing.

I Have created the DB Auditing but I dont know how to schedule the email alert with this option?

Coming to Trigger, I dont know how to write trigger sql with this option.

so can anyone please help how to get the email alert if any changes happened in this table?

Comments

Post Details

Added on Nov 21 2018
#general-database-discussions
11 comments
8,423 views