Oracle Instead of Trigger Question

greenspun.com : LUSENET : DBAzine : One Thread

I got a view on a table, and an instead-of-trigger for insert, update on the view. I would like ask how can I do something once per triggering statement, instead of once per row, in the instead-of-trigger?

p.s. For some reason, I MUST use instead-of-trigger on view instead of before/after trigger on table

-- Douglas Kei (dkei@hydra.com.hk), May 25, 2004


Moderation questions? read the FAQ