Search code examples
sqloracle-sqldeveloper

I can't figure out how to update data with triggers

CREATE TABLE fav_sports 
(
    ID int,
    sport varchar(20)
);

CREATE TABLE try_outs 
(
    ID int
);

CREATE TRIGGER players 
BEFORE INSERT ON fav_sports 
FOR EACH ROW 
BEGIN
    INSERT INTO try_outs VALUES(NEW.ID);
END;

Whenever I try to update "try_outs" with the "players" trigger, I get an error - "SQL statement ignored" and "column not allowed here".

Please help.

The program throws errors when creating this trigger.

Solution

  • Small syntax error. Change:

    NEW.ID

    to:

    :NEW.ID

    So the full line looks like:

    INSERT INTO try_outs VALUES(:NEW.ID);

    See live demo.