Get event information in triggers in PL/SQL

Asked By Agustin L Stanley 20 points N/A Posted on - 10/19/2014

I want to receive event information in triggers in PL / SQL. I have to add a trigger in Oracle which is raised or update a particular table. Inside the trigger, I want the event to determine the trigger (if insert or update) causes. How do I determine the event information in SQL PL?

• Status: Open
• Question Views: 630
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: Oracle Database

Answered By Moreen Jamnelly 10 points N/A #188175

Get event information in triggers in PL/SQL

Hello, How are you? You can solve the issue using the “INSERTING” and “UPDATING” keywords. Now use the following command to solve this issue :

IF INSERTING

THEN

     <<do something>>

END IF;

IF UPDATING

THEN

     << do something else>>

END IF; 

So, you have to write the above written command for inserting and updating keywords. That is exactly it.

Moreen Jamnelly.

 

About Moreen Jamnelly

Questions
0

Answers
101

Best Answers
3

• Vote Up 0 Vote Down

• Posted on - 10/23/2014
• Question Category: Oracle Database