Oracle triggers if inserting updating

By default each trigger is Statement-Level trigger for making Row-Level trigger we use key word FOR EACH ROW in create trigger statement. Before and After Triggers: There are two types using of these triggers BEFORE and AFTER.

Statement level triggers are usually used for Row-Level Triggers: A Row Level trigger fired every time for each row if we want to insert, update and delete data in table like if we performed DML operation on table and there are 20 rows that are effected then trigger will be executed 20 time on the other hand Statement-Level trigger fired one time. If you feel a blog entry is inappropriate, click here to notify Toolbox for IT.Welcome to Linux Questions.org, a friendly and active Linux Community. By joining our community you will have the ability to post topics, receive our newsletter, use the advanced search, subscribe to threads and access many other special features. For more advanced trainees it can be a desktop reference, and a collection of the base knowledge needed to proceed with system and network administration.I noticed that you cannot make an update or insert in a trigger that is triggered off by an insert on the same table. In the word table there is a 'one_word' BOOLEAN attribute (I know, the purists will tell me it should be here, but that's not the point), when someone inserts the word (or multiword expression) "Linux Questions" (two separate words separated by a space), I would like that tuple's one_word attribute set to FALSE.If someone inserts "Linux Questions" (in a single word) I'd like that attribute set to TRUE, with a trigger, or another way so long as it is automatically updated after an insert.The regex's don't pose a problem, of course, it's the trigger acting on the same table that activated it that does.

619

Leave a Reply