INSTEAD OF triggers when creating or replacing view

[Milan]

When you run CREATE OR REPLACE VIEW in a command window, existing INSTEAD OF triggers on the view are dropped (this is consistent with SQL*Plus). However, when you do it in a SQL window, the triggers are not dropped.

Does anyone have an explanation? Is this a PL/SQL Developer feature?

I am using version 9.0.6

 

[Marco Kalter]

This is indeed a SQL Window feature. When recreating a view it saves and restores its triggers.

 

[Rich Hull]

...and a wonderful feature it is! I can't tell you how many times I've lost INSTEAD OF triggers when making changes to views using other PLSQL tools.

However, the PSD "Compare User Objects" feature is not so accomodating. When it detects a difference in the view, it does NOT (but I think, SHOULD) automatically include all INSTEAD OF triggers defined for the source view.

Of course, if there was a change to the trigger itself, it includes it. But, it's common that a change to a view (e.g., the query predicate) would not require a corresponding trigger edit.

 

[Marco Kalter]

We'll enhance this.