Oracle trigger if updating then

Rated 4.65/5 based on 987 customer reviews

You can refer to the previous tutorial “Introduction to Triggers” anytime.

I have created this table with the name SUPERHEROES which has only one column sh_name with data type varchar2 and data width 15.

v_user); END; / On successfully compiling, this trigger will show you a string along with the user name who performed the “Insert” DML on superheroes table.Now I will write a DML trigger which will work on this table. Now let’s do some examples which will help you in understanding the concepts more clearly.Before that a simple tip: Always remember to set your server output ON otherwise the output message returned from your trigger will not be displayed back to you.

Leave a Reply