Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: insert/update triggers by same name....
mberger_at_skypoint.com wrote:
>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;
If those statements are executed, the second one will replace the first...Are the designed to be run in different Schemas? Received on Mon Oct 18 2004 - 13:28:22 CDT