DBST 651 (Formerly CSMN 661) Sample Scripts: Trigger

SPOOL MARY_TRIG

DROP TRIGGER ZIP_TRIG;

CREATE TRIGGER ZIP_TRIG AFTER INSERT ON ZIP FOR EACH ROW

BEGIN

DBMS_OUTPUT.PUT_LINE('The insert worked. Good job!!!!!!!!!');

END;

/

SPOOL OFF

Home

©2003-2004 by McGraw - Hill Companies, Inc. All rights reserved.