Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Trigger on nested table column
Hello,
Is any way to fire trigger when user use unnesting queries like this:
INSERT INTO TABLE(SELECT nested_table FROM parent_table WHERE id = 1) VALUES
....
UPDATE TABLE(SELECT nested_table FROM parent_table WHERE id = 1) SET...
DELETE FROM TABLE(SELECT nested_table FROM parent_table WHERE id = 1);
or restrict such operations.
I find that triggers on parent_table don't work in that case.
I can't believe that isn't any way to control user actions on this kind of columns.
Thanks,
Danil
Received on Sat Nov 30 2002 - 03:25:12 CST