Re: quick question about after statement triggers

On Thu, 20 Oct 2005 20:45:24 +0000, Jack Addington interested us by writing:

>
> hmmm.. so just to clarify, the statement triggers are firing for each
> statement, not each type of statement. I had this embarassing illusion/idea
> they were statement triggers were more related to the transaction/commit.

Triggers are a fairly large body of learning - discussed in detail in the "Application Developer's Guide - Fundamentals" manual in the 'USING TRIGGERS' chapter, and in the "SQL Reference" manual (under CREATE TRIGGER) - both books being at http://docs.oracle.com (look for 'View Library' then 'List of Books' for your version of interrest.)

To shorted your search - there is a 'FOR EACH ROW' clause that will turn the trigger into a 'per row' trigger.

-- 
Hans Forbrich                           
Canada-wide Oracle training and consulting
mailto: Fuzzy.GreyBeard_at_gmail.com   
*** I no longer assist with top-posted newsgroup queries ***