Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> trigger syntax for after insert

trigger syntax for after insert

From: Alen Cappelletti <alen.cappelletti_at_gmail.com>
Date: Mon, 02 Jul 2007 07:26:46 -0000
Message-ID: <1183361206.429692.156070@m36g2000hse.googlegroups.com>


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
;

  END IF;
END;
/ Received on Mon Jul 02 2007 - 02:26:46 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US