Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Trigger: how to get inserted/updated rows in bulk?

601248May 29 2008 — edited May 29 2008
Hi,

I'm creating a trigger. In the trigger, I would like to get all inserted (or updated) rows in order to do a "group by" statement and traverse only a subset of all inserted rows. How would I go about doing that? In SQL Server, there is the inserted or deleted virtual tables which hold all the inserted/deleted rows in a session. Is there anything equivalent in Oracle? The Old and New variables are not quite it, since they only reference one single row at a time.

Thanks
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 26 2008
Added on May 29 2008
4 comments
2,457 views