Get event information in triggers in PL/SQL

Asked By 20 points N/A Posted on -
qa-featured

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?

SHARE
Answered By 10 points N/A #188175

Get event information in triggers in PL/SQL

qa-featured

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 keywordsThat is exactly it.

Moreen Jamnelly.

 

Related Questions