Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> insert/update triggers by same name....
Hello all,
I'm relatively new to Oracle, and came across a .sql script file to
use to update a release for a product I support. It contains the
following tr_supervisorupdate triggers, for insert AND for update. Does
Oracle allow this ? It seems to me, this is an error on the part of the
developers that supplied me with this script.
Thanks,
Mike
CREATE OR REPLACE TRIGGER tr_supervisorupdate AFTER INSERT ON PWSUPER
FOR EACH ROW
DECLARE newSupID NUMBER;
BEGIN
blah-blah-blah
END tr_supervisorupdate;
/
CREATE OR REPLACE TRIGGER tr_supervisorupdate AFTER UPDATE ON PWSUPER
FOR EACH ROW
DECLARE newSupID NUMBER;
BEGIN
blah-blah-blah
END tr_supervisorupdate;
Received on Mon Oct 18 2004 - 13:07:39 CDT
![]() |
![]() |