Skip to Main Content

SQL Developer

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!

How to export view with instead of trigger

Marko GorickiFeb 8 2018 — edited Feb 9 2018

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:

pastedImage_3.png

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:

pastedImage_4.png

Thanks in advance for help!

I'm using SQL Developer 17.4.0.355 on Mac.

Br,

Marko

This post has been answered by thatJeffSmith-Oracle on Feb 8 2018
Jump to Answer

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Mar 8 2018
Added on Feb 8 2018
1 comment
439 views