Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> trigger syntax for after insert
Hi all,
the sysntax above is correct? 'Cause when I compile a got an error...
TNKS Alen
CREATE OR REPLACE TRIGGER AFT_IN_TEAMS
AFTER INSERT ON TEAMS
BEGIN
IF :NEW.Privato = 1 THEN
INSERT INTO TEAMCOMPOSIZIONI (IDTEAMRIFERITO,IDTEAM) VALUES (
:NEW.IDTEAM,
:NEW.IDTEAM
;