Re: Can I have an instead of update and insert triggers on the same view?

create or replace trigger view_insert
instead of
insert
on my_view
begin

    null;

• some other code end; /

then replace insert with update / delete.

If this doesn't work, it is possible that your version / level of Oracle doesn't
support INSTEAD OF triggers.

NB It is usually very difficult to
code such triggers correctly.

--
Jonathan Lewis
Yet another Oracle-related web site:  http://www.jlcomp.demon.co.uk

Practical Oracle 8i:  Building Efficient Databases
Publishers:  Addison-Wesley

Reviews at: http://www.jlcomp.demon.co.uk/book_rev.html



don wrote in message <0u15btco7vpgt10k9nsea67c8bpl6isj53_at_4ax.com>...


>I have a view which I need to insert into, update, and delete from.

>How can I create instead of triggers for each of these actions?

>

>Thanks,

>   Don