Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / Trigger

 

REFERENCING OLD AS old_values NEW AS new_values

SQL>  CREATE TABLE game_player   2  (player_id    NUMBER,   3   game_id      NUMBER,   4   group_number NUMBER,   5   marked       VARCHAR2(1) DEFAULT 'N',   6   pcmac        VARCHAR2(1) DEFAULT 'N',   7   score        NUMBER,   8   CONSTRAINT game_player_pk   9   PRIMARY KEY (player_id, game_id, group_number)); Table created. SQL> SQL> -- changing the defaults SQL> CREATE OR REPLACE TRIGGER old_new_delete   2  BEFORE delete ON game_player   3  REFERENCING OLD AS old_values NEW AS new_values   4  FOR EACH ROW   5  BEGIN   6    DBMS_OUTPUT.PUT_LINE('Old marked = ' || :old_values.marked);   7    DBMS_OUTPUT.PUT_LINE('New marked = ' || :new_values.marked);   8  END;   9  / Trigger created. SQL> SQL> drop table game_player; Table dropped.