Hi,
is there an easy way to export view together with instead of trigger created on the same view?
For example, if you create view and instead of trigger like this:
-- view
create or replace view v_dummy as
select 1 a
from dual;
-- instead of trigger
create or replace trigger v_dummy_ioiu
instead of insert or update on v_dummy
referencing new as new old as old
for each row
begin
null;
end;
If you go to the export option (right click on View > Export) with this properties:
you will get only view code (create or replace view...). If you select option Dependents you'll get all depended object, but no trigger.
The code that I want is visible if you right click on view > Open > tab SQL:
Thanks in advance for help!
I'm using SQL Developer 17.4.0.355 on Mac.
Br,
Marko