I want to use a statement-level trigger for "after insert". There should be a table of tuples that is inserted, which is the "new table" according to SQL standard. How could I reference it in Oracle? I know there are functions to reference the new rows in row-level trigger, but not for statement-level trigger. I have looked for many documents and articles but none of them mention this. Does Oracle have this function? Thank You.
T211, Basic trigger capability
Oracle's triggers differ from the standard as follows:
* Oracle does not support OLD TABLE and NEW TABLE; the transition tables specified in the standard (the multiset of before and after images of affected rows) are not available.