|
SQL>
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>
SQL> -- explicit default old and new
SQL> CREATE OR REPLACE TRIGGER old_new_update
2 BEFORE update ON game_player
3 REFERENCING OLD AS old NEW AS new
4 FOR EACH ROW
5 BEGIN
6 DBMS_OUTPUT.PUT_LINE('Old marked = ' || :old.marked);
7 DBMS_OUTPUT.PUT_LINE('New marked = ' || :new.marked);
8 END;
9 /
Trigger created.
SQL>
SQL>
SQL>
SQL> drop table game_player;
Table dropped.
|